Hi,
I have two tables,
Table A ( field Color)
Table B (field color, field cloth)
relation - TableB.color == TableA.color
In form,
added both the tables as data sources.
Tab page A - field color from Table A
Table page B - field cloth from Table B
I want to get for a singe record in Field color, it should be able to create and show multiple Records in cloth field.
Tab page A
Color
Blue
Tab page B
Cloth
Shirt
Coat
Tie
How do I get this. when I am giving inner join or outer join in the table A datasource to table A datasource, it is showing Blue also multiple times.
If i give delayed or active, its showing one one record only . now showing multiple in Cloth field