In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

How to set Master-child relationship on multiple fields

FastReport for Xailer & [x]Harbour (English/Spanish)
Milan Mehta
Posts: 113
Joined: Sun Dec 27, 2009 9:54 am

How to set Master-child relationship on multiple fields

Postby Milan Mehta » Sat May 28, 2016 7:24 am

Please help me with an example of how to set Master-Child Relationship on Multiple Fields using :SetMaster().
User avatar
bingen
Posts: 440
Joined: Mon Jul 07, 2014 8:17 pm
Location: Bilbao
Contact:

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

Postby bingen » Thu Jun 02, 2016 4:09 pm

For DBF Files?

oFr:SetMasterDetail ("Clients", "Orders",{||Clients->Code})
BiSoft Desarrollo de software profesional
http://www.bisoft.es
Milan Mehta
Posts: 113
Joined: Sun Dec 27, 2009 9:54 am

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

Postby Milan Mehta » Fri Jun 03, 2016 2:28 pm

No we use Sqlite. Can you guide ?

TIA
Milan.
User avatar
bingen
Posts: 440
Joined: Mon Jul 07, 2014 8:17 pm
Location: Bilbao
Contact:

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

Postby bingen » Thu Jul 07, 2016 1:09 pm

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.
BiSoft Desarrollo de software profesional
http://www.bisoft.es

Return to “FastReport”