Table size?

[IwannaBNVegas]

Hi,

I'm very new to Access. I've been trying to build a DB for my (moving & relocation) company.
Here's my dilemma:

I'm not sure if I should list most details in one table, or, like I did, split everything up.

So far I have a few of tables:
- Shipper's (the people moving), with their current address
- Origin address
- Destination address
- Container1
- Container2
- Car1
- Car2
- Agents
- services offered

Now, does it make more sense to put the information that will be different for each shipper in one long table? Like name, address, origin, destination, container1 and 2, car1 and 2, and have the "constants" in a different table (like agents and services offered)?



I hope this makes sense. If not, please let me know I'll try to clarify.

Thanks,
Sylvia

[June7]

I see the entities of your data as:

Customers
Services
Agents

Then to allow for repeat customers, a junction table to associate the participants for each moving job:

JobOrder
OrderNum (PK)
CustomerID (FK)
ServiceID (FK)
AgentID (FK)
DateOrder
Origin
Destination

Not sure what the similar container and car fields are about. Might be okay in the JobOrder table, might should be child table(s).

[IwannaBNVegas]

Thanks for your reply.
The Household goods and vehicles are transported in a shipping container. That's what the containers are for. Most of our customers are overseas and many of them take vehicles.
I will try it the way you show it and include the vehicles and the shipping containers in the JobOrder table.
Thanks again!