Many to Many Relationship - 3+ Tables
Scenario: (will be using terms from Criminal Minds) Table: Intake Intake collects up to 5 Phone Numbers 5 Email Addresses 5 Websites 1 Name 1 Alias Names are not Unique Alias Must be ...
Forum Discussion
Can you explain what relationships you have in place now are what what the key field is of your Alias table? is it [Record ID#] or [Alias].
Key Fields:
Intake: Record ID#
Info: Data ID# (renamed Record ID)
Alias: Alias (text field)
Unsub: Unsub (text field)
Relationships:
INTAKE:
Many Intake Reports belong to a Single Alias
Many Intake Reports belong to a Single Unsub
INFO:
Many Data Points Belong to a Single Unsub
ALIAS
Many ALIAS belong to One Unsub
UNSUB
has the three references prior.
Intake: Record ID#
Info: Data ID# (renamed Record ID)
Alias: Alias (text field)
Unsub: Unsub (text field)
Relationships:
INTAKE:
Many Intake Reports belong to a Single Alias
Many Intake Reports belong to a Single Unsub
INFO:
Many Data Points Belong to a Single Unsub
ALIAS
Many ALIAS belong to One Unsub
UNSUB
has the three references prior.
