A quick question... I've got a form based on a table called:
Client ------ PK IdNo 3 other tables are added to this form: ClientDay --------- PK ClientDayID FK IdNo (Client) FK DayID (Day) ClientDayItem ------------- PK ClientDayItemID FK ClientDayID (ClientDay) FK MealSubItemID (MealSubItem) ClientDaySubItem ---------------- PK ClientDaySubItemID FK ClientDayItemID (ClientDayItem) FK SubItemDetailID (MealSubItemDetail) If I drop 4 DBGrids on the form, one for each table, only the one based on ClientDay seems to link back properly, even though all the tables have PK/FK relationships. Is there a 2 table limit for this sort of thing? Thanks Lucas
