Help with linking multiple tables

H

huzefahashim

Hello everyone!
I am working on this project which has multiple relationships. I have
7 tables with one of them being the main table. All tables are linked
with the main table's Primary Key. Now, so far everything is working
fine. But another requirement is that, one of the tables is for
Approvals. In that table, there can be multiple Submissions until the
product gets approved. The products are, different fields in different
tables. Some of the fields are multiple fields in one table. One table
has 9 fields which need to be linked. Another has 2 fields. Another
has 3 while another has 1.
I cannot figure out how to best link those with the Approvals. Any
ideas to figure out the logic? I'm sorry for the confusion I probably
have caused. If there needs to be some clarification, please let me
know.
Thanks!
 
Top