I'm creating an order form that has a Customer, a Pickup and a delivery contact. Sometimes my customer is also the pickup or delivery, sometimes its three different contacts. How do I set up my order form to pull information for all three contacts. Understanding relationships between tables do I need to set up a master "Contact" table and then seperate "Customer", "Pickup" and "Delivery" tables or can I pull from just the "Contact table"?

---

Reply from Richard Rost:

Ideally, you would want 2 different tables here. One for your "contact" as you call it, and then a second table to store the related information (customer, pickup, delivery). This is a classic one-to-many relationship. I have NOT covered this yet as of Access Beginner Level 6. I will be covering it in Access Expert Level 1. If you want to learn it now, you can see Access 201 (for 2003) or my Access Relationship Seminar.