Adding the same field from a table twice in one form?

[Go3Team]

Trying to do this, with no luck. I'm trying to design a dispatch software for a small trucking company and trying to be able to put the pick up and delivery locations in one table, because at one time or another, the locations will either receive or ship. But when I go to make the form, the duplicate fields repeat the information from the first fields located at the top of the form. Is there any way I can avoid this? Thanks.

 

[diversoln]

I would set up the shipping table with a "shipfrom" field and a "shipto" field. You can set up your form with combo boxes to select your responses from a list. The combo boxes could both be based on the same table maybe called locations. Then you could run an append query to add the values in the combo boxes to your shipping table.