exporting like-for-like fields across databases

[Jimmie99]

Hello all,

I have, lets say for simplicity's sake, two databases. One database (X) stores a master list of 100 conferences. I have twenty clients who are interested in going to conferences.

For each conference you can attribute two clients or more, for example. Therefore I used another database (Y) to allocate clients to specific conferences. So I pull records from the master and adapt them as I need. But all the time, the master database of conferences in X remains untouched.

When I find a conference in X that suits a specific client, I want to export it to Y.

I have created a basic script called 'export record found'. This exports records as tab seperated text, I allocate fields I want to export and save the export on the desktop.

Then manually I go to Y, and import the records, choosing each field I want to attribute to each field I have in Y. The fields in X and Y are the same. The only different in Y are the notes I add to each record for each different client.

Is their a better way to automate the process. At the moment, I am effectively transferring like-for-like records. Their must be a way of simply shifting the data across at a touch of a button.

I hope this description helps. Many thanks in advance!

JAMES

[Vaughan]

If the records are basicaloy the same then perhaps they *are* the same, from a data design perspective.

You may just need another related file.