Multi Stops Solution

[Guest]

I define "Shipper" in the table as Customer who is shipping product and
"Receiver" is Customer who is receiving product. I also define "Truck" as
Equipment that will transport load from Shipper to Receiver.

Now I need to find solution when Truck has several number of Shippers or
Receivers.

One solution that I currently have is to define another table "Shipper
Sequence" which will have AutoNumber Primary Key + Shipper ID + Shipper ID +
.... + Shipper ID. I can assume that is not going to be more than 10 shippers
or receivers for one load and than work with Shipper Sequence, Receiver
Sequence and Truck.

But this solution doesn't look good to me because I have static tables with
1+10 columns no matter I have 1 or 10 shippers or receivers.

Is there any way that I can make dynamic table which will have only have 1
(Primary Key) + actual number of shippers or receivers columns?

Thank You

 

[HELENA SMITH]

(e-mail address removed) hi are you

 

[HELENA SMITH]

(e-mail address removed) hiare you