George10988
Registered User.
- Local time
- Yesterday, 22:53
- Joined
- Apr 23, 2011
- Messages
- 41
Hello, I have a very complex relationship of about 10 tables with many, many to many relationships. For some reason I am having a hard time getting the PK in one table to fill in the FK in another table. For example, IF my PK in the first table is an autonumber and i fill in a persons name I want that PK to transfer to the FK in the second table automatically as soon as I start to fill in the fields that are related to that person that reside on the second table. I have done this before and it worked but only when I did not have many to many relationships. IS there a way to use multiple subdatasheets to associate one table to many child fields?