Within my FM database I have a table that imports text files via a script. Each file has multiple addresses, i.e. Name1, Address1, City1, State1, and Zip1 all the way to Name10, Address10, City10, State10 and Zip10. I want to create a table so that when this data is imported, it takes each address and creates its own record in a new table. It would also assign each address a unique ID based on the number of the address and the OrderID that is also provided.

Any help would be greatly appreciated.

I would think the easiest way might be to just do 10 imports.

Import 1:

Address1=Address

Import 2:

Address2=Address...

Import 10:

Address10=Address

If there are not always 10 addresses, you will also need to script a cleanup of empty records.

HTH

-Raz