problem with master-detail relationship

Question

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