Many To Many Relationship Help
I have a table called Client Profile and then three other tables.
Tables: App1, App2, and App3
App 1 and App 2 I have related to client profile database with the clients social security number. I have portal windows to show related records to those applications, however the trouble is App3. App3 is already related to another table so when i try to relate it to client profile. It wants me to create another occurrence of client profile. I'm confused on how this is going to sync. What do i do ?