how to design 3-tier table relationship

how to design 3-tier table relationship

anders59anders59 Posts: 4Questions: 2Answers: 0
edited July 27 in Free community support

Dear Sir,
I'd like to design a 3-tier table relation for customer.
for example:

TableA (parent): 
  id ,

TableB(child of TableA):
  TableA_id (from parent),

TableC(child of TableB)
  TableC_id (from id of TableB)

I built successfully TableA and TableB relationship as our example
but failed to link TableC.

I got an error messge from data function listed below.

data: function ( d ) {
                var selected = TableB.row( { selected: true } );
                if ( selected.any() ) {
                    d.TableC_id =;

Because I used explicitly field expression,, TableC.TableC_id in my editor and table column,
How can I replace "id" in "" with the right expression?
(If I replaced "" with "",
I'll got a wrong expression warnning) .

Hope to hear the right answer here!

Edited by Allan - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.


  • allanallan Posts: 54,528Questions: 1Answers: 8,526 Site admin

    Can you give me a link to the page you are working on so I can see how you are configuring the DataTables, Editor and also the data being returned from the server please.


  • anders59anders59 Posts: 4Questions: 2Answers: 0

    Hi Allan,
    I've solved this issue already.
    I just replace the statement
    ''' d.tag_tagvalue_id = '''
    ''' d['tag_tagvalue_id'] =['id]'''
    Thank you!

Sign In or Register to comment.