How to set Master-child relationship on multiple fields

[Milan Mehta]

Please help me with an example of how to set Master-Child Relationship on Multiple Fields using :SetMaster().

[bingen]

For DBF Files?

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

[Milan Mehta]

No we use Sqlite. Can you guide ?

TIA
Milan.

[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.