Linking multiple tables by primary key...
Posted on 2000-04-20
Hello. Can anyone help?
When I try and link more than 3 tables all by their primary key, access won't cascade update/delete the related fields in all of the tables.
Basically we're storing a truck-load of data on people and it won't fit into only 1 or 2 tab's. So I want to link them all by the same field (numbers) in each table using 1-1 relationships and referential integrity. But it won't update all the tables when I add a new record.
Anybody now why, or more importantly, how to make it work?