Importing data to related fields from an external file
I just created a new database to hold Order and Customer records. The file I am pulling data from has all of the customer and order data intermingled. The file is a plain jane tab deliniated .txt file. The file is filled with thousands of orders and contacts, bith of which should stay connected in the database like the orders that have been input by hand.
The problem I am having is that I don't know how to import all the record fields at the same time. When I am in the customer layout I can't populate the related fields on the page that references the orders table.
My question is how can I import data to all the fields at the same time?