Wrong field type - invoicing - used relational vs lookup field

[skingjack2]

Due to stupidity on my behalf, It was determined that I had used relational

data for name/address/city/state/zip fields when creating an invoicing database; the question,

is there an easy way to correct without having to resort to importing data into a properly setup

invoicing solution.

 

Open to any suggestions...

 

Jack

[Brooks]

That is too wide of a question. You'll need to be more specific with your situation and desired outcome. A shot in the dark answer. Add the correct fields to your invoice table and loop through the existing records and copy the data from the related tables to the new fields.

[Matthew F]

I presume your goal is to copy data to an invoice table from a directory of clients...

 

You could define the corresponding address fields on the invoice table with the option "auto-enter" as look-up values.  When new invoices are created the clients current address will be automatically entered, but the old invoices will be unchanged. This is useful if the clients address changes -- you don't want all your old invoices to change. 

 

To copy data from the client directory to the invoices first search for the invoices that you want to update.  Then run a script with a "Relookup field contents" step (specify the relationship's match field as the 'target field').   This will copy the current client data over to your invoices -- but be careful not to select invoices which should reference older address.