[nerkn]

hi,

how can I define relation for such a problem:

 

Invoice (id, name) and invoiceLine(id, invoice, name)

 

(I can handle this "office (id, user_id)  users(id, name)" but not above?)

 

[Amit Shah]

please elaborate what exactly you want in here so someone can give u some solution

[nerkn]

invoice (id:333, items:3, total:300,date:'2014-11-24')

• invoiceLine(id:1501, invoice:333, name:potato, price:100)
• invoiceLine(id:1502, invoice:333, name:apple , price:150)
• invoiceLine(id:1503, invoice:333, name:coke  , price:  50)

can you construct relation in grocerycrud?

[Amit Shah]

well.. sorry to stay but still didnt understand ..

as what exactly u wana show and where..

is it in the form ... is it in the listing .. where and what.. ?

[cybersven]

I think what you looking for is :

$crud->set_relation('id','invoice','invoice');

first id from invoice (id:333, items:3, total:300,date:'2014-11-24')

then the table from invoice (id:333, items:3, total:300,date:'2014-11-24')

then the column from invoiceLine(id:1501, invoice:333, name:potato, price:100)