Hello everyone - I'm a bit wet behind the ears in the old database department, so bear with me.

I have created an invoice database with a main customer information database related to an invoices database. Each customer has their own unique ID number generated from the auto-serial function. I can MANUALLY enter this number into the corresponding field in the invoices database, and it will lookup the customer's information appropriately.

This is great, but I want to make a button that I can press that will cause the open "invoices" window to update, displaying the customer info in the currently open record in the "customer info" database. - I basically want to copy the customer ID from the customer info and place it into the invoices window.

I hope this is semi - clear. Take number from window A and put it in window B, causing window B to reflect window A.

Thanks to anyone who can help.

Take care,

Jeff

I had it working great in FM5, but having problems getting it to work the way I want in FM7. The command you want to use it 'go to related record' and set it to call up a new window.

I want to make a button that I can press that will cause the open "invoices" window to update, displaying the customer info in the currently open record in the "customer info" database.

This is the script to put under the button:

Show All Records

Omit

Show Omitteded

Relookup[no dialog]

Show All Records

...it's important to know which field trigs the lookup!

--sd