Treason
#@$%#!
- Local time
- Yesterday, 23:38
- Joined
- Mar 12, 2002
- Messages
- 340
I am pretty good in VBA, but normalizing databases is not my strong suit. I am missing a major piece of insight. Here's the situation. I am building a shipping db and after I create the relationships between my tables I fail to see how to add new records. I am assuming I would have to build forms to make it easy on the end user, because users would NEVER remember all the key field values. I thought I could just create a query with all the tables joined and then make it the recordset of a form and data entry would be simplified. I think it is failing because I am enforcing referencial integrity, but maybe it's my joins?
I am getting a headache, lol
Here's a pic of my ERD
What am I missing here?
TIA
I am getting a headache, lol
Here's a pic of my ERD
What am I missing here?
TIA