As a point of reference I have a few posts on this site for a baseball card database I am trying to create (very slowly).
Reference:
Summary:
In the linked post above I have a Join Table I have created so that I am able to further normalize and "link" all of the tables to accommodate 1 card with multiple players, 1 player with multiple cards, 1 player with multiple teams, 1 card with multiple players and multiple teams, etc through these subdatasheets Access automatically inserted.
Problem:
I have read many posts that claim lookup fields are evil but I don't know how else normalize data further in Access.
Take a more simple example with just two tables--
When I create a [tblTransactions] and find that a (fieldCustomers ) needs to be broken out into it's own table to further normalize the data I would create a 2nd table [tblCustomers] and then have the (fieldCustomers ) in the [tblTransactions] lookup the field the the 2nd table [tblCustomers] to create the relationship.
Question:
How should I go about properly creating relationships in Access when I normalize tables given my problem or confusion stated directly above?
As always, I appreciate the many people on this forum who are so helpful with their replies despite my painful lack of knowledge and inability to grasp this stuff more quickly.
Reference:
Summary:
In the linked post above I have a Join Table I have created so that I am able to further normalize and "link" all of the tables to accommodate 1 card with multiple players, 1 player with multiple cards, 1 player with multiple teams, 1 card with multiple players and multiple teams, etc through these subdatasheets Access automatically inserted.
Problem:
I have read many posts that claim lookup fields are evil but I don't know how else normalize data further in Access.
Take a more simple example with just two tables--
When I create a [tblTransactions] and find that a (fieldCustomers ) needs to be broken out into it's own table to further normalize the data I would create a 2nd table [tblCustomers] and then have the (fieldCustomers ) in the [tblTransactions] lookup the field the the 2nd table [tblCustomers] to create the relationship.
Question:
How should I go about properly creating relationships in Access when I normalize tables given my problem or confusion stated directly above?
As always, I appreciate the many people on this forum who are so helpful with their replies despite my painful lack of knowledge and inability to grasp this stuff more quickly.
Comment