Can I use a compound index to enforce referential integrity between tables? If that works can I use cascade update/delete? If that isn't possible I would use an autonumber field in the primary table, but how would I relate records to the subsidiary tables?
I have 12 subsidiary tables to relate to 1 primary table.
I appreciate any and all comments and suggestions!