Subject | Master-details link with a OR statement |
---|---|
Author | johnme199 |
Post date | 2007-07-27T09:13:33Z |
Hi,
I just want to do a master-detail relationship with a OR statement:
Table1 (master)
NOIDTABLE1
...
Table2 (detail)
NOIDTABLE2
NOIDTABLE1A
NOIDTABLE1B
...
I would like to show in a grid the records of table2 if
NOIDTABLE1A=TABLE1.NOIDTABLE1
or
NOIDTABLE1B=TABLE1.NOIDTABLE1
if I put the 2 relationships in the masterlinks box, I've got a AND
and not a OR statement
Any idea how I could do that ?
Thanks
Jean Vandromme
Belgium
I just want to do a master-detail relationship with a OR statement:
Table1 (master)
NOIDTABLE1
...
Table2 (detail)
NOIDTABLE2
NOIDTABLE1A
NOIDTABLE1B
...
I would like to show in a grid the records of table2 if
NOIDTABLE1A=TABLE1.NOIDTABLE1
or
NOIDTABLE1B=TABLE1.NOIDTABLE1
if I put the 2 relationships in the masterlinks box, I've got a AND
and not a OR statement
Any idea how I could do that ?
Thanks
Jean Vandromme
Belgium