problem with master-detail relationship
hi
i have an issue with master-detail relationship.
i have 3 tables in a ms access database. table A and C are master tables, table B is the detail table.
table A:
col 1 (primary key)
col 2
col 3
-----------------------------------------------------------
table B:
col 1 (referential integrity to col 1 in table A)
col x (referential integrity to col x in table C)
col a
col b
(col y)
(col z)
-----------------------------------------------------------
table c:
col x (primary key)
col y
col z
i use grid to present table B and would like to include col y and z in the grid so that they get populated with correct values when col x in the grid is filled in.
or is there a workaround to achieve this?
thanks in advance for your help
rgds
treo