Page 1 of 1

How to set Master-child relationship on multiple fields

Posted: Sat May 28, 2016 7:24 am
by Milan Mehta
Please help me with an example of how to set Master-Child Relationship on Multiple Fields using :SetMaster().

Re: How to set Master-child relationship on multiple fields

Posted: Thu Jun 02, 2016 4:09 pm
by bingen
For DBF Files?

oFr:SetMasterDetail ("Clients", "Orders",{||Clients->Code})

Re: How to set Master-child relationship on multiple fields

Posted: Fri Jun 03, 2016 2:28 pm
by Milan Mehta
No we use Sqlite. Can you guide ?

TIA
Milan.

Re: How to set Master-child relationship on multiple fields

Posted: Thu Jul 07, 2016 1:09 pm
by bingen
Sorry I use Mysql/MariaDb no SqLIte, but yo can make a bigger select wit joins in order to have one unique dataset with a mix of fields of first (with repeated values) and second tables and use into FR one dataset only with all the fields you need.