Looking for advice with the following relationship....
Primary Tables
Filing(Number, Title, Analyst,etc)
Form(FormNumber, Title, Type, Desc, etc)
State(Name, Abrv, Address, etc)
Bridge Tables
FilingForm(FilingNumber, FormNumber)
FilingState(FilingNumber/FilingFormNumber??,State, MailDate, ApprovalDate, etc)
*A 'filing' is a compilation of 1-many 'forms' that is sent to states for approval.
*A 'filing' may be sent to 1-many 'states'
*A 'form' may be in 1- many 'filings'
*A 'state' will receive many 'filings'
I'm not confident of how the tables should be set up to allow for the multiple many to many relationships.
I'm in the process of trying to sketch making my access forms for this relationship and it needs refinement.
Please feel free to ask questions to help clarify.
Thanks!!!!
Primary Tables
Filing(Number, Title, Analyst,etc)
Form(FormNumber, Title, Type, Desc, etc)
State(Name, Abrv, Address, etc)
Bridge Tables
FilingForm(FilingNumber, FormNumber)
FilingState(FilingNumber/FilingFormNumber??,State, MailDate, ApprovalDate, etc)
*A 'filing' is a compilation of 1-many 'forms' that is sent to states for approval.
*A 'filing' may be sent to 1-many 'states'
*A 'form' may be in 1- many 'filings'
*A 'state' will receive many 'filings'
I'm not confident of how the tables should be set up to allow for the multiple many to many relationships.
I'm in the process of trying to sketch making my access forms for this relationship and it needs refinement.
Please feel free to ask questions to help clarify.
Thanks!!!!