I've setup a db according to the structure layed out in the wiki regarding normalization.
As a certain customer can have different type addresses, I have a form to fill in the name of the customer and a subform to fill in the different addresses. On the form are also subforms for email, phone and rebate.
When inserting a new customer I copy the custID using code to the different subforms in order to get the correct relations to work.
This results in a couple of pop-ups: can't add or change record because there is no related record in tblCust.
I can click "ok" on every pop-up and everything goes through. I guess I can set warnings off in order to prevent the pop-ups.
Another problem I have with this is when the user decides to stop entering of the new customer (for wathever reason), a record is added to tblCust, tblCustAddress, ...
Long story short: can someone guide me towards a "standard"-setup for entering a new customer or tell me what I'm doing wrong?