Hello Rost,

Access Work Order Seminar:

The first table you created was CustomerT.  My husband business consist of residental and commerial companies.  I notied that you only enter one company but when you need to add more companies, how would I do this?

---

Reply from Richard Rost:

If you're saying that you need to be able to store multiple company names for one "customer" then you can either add additional fields to the same table, or use a 2nd table. The first option is fine if you only have 2 or 3 company names you need to track. If you need 4 or more, I'd use the related table. It's like tracking multiple parents for a child. If you only need mother's name and father's name, then 2 fields in 1 table gets you by. However, if you need to also track other parents, guardians, grandparents, etc. then you might want a 2nd table. Basic one-to-many relationship.