Take data from one window and copy into another?

[jeffdoto]

Hi everyone -

I'm building a customer info database with invoices. I currently have a customer info databse linked to an invoice database. The customer info databse generates a unique customer ID for each customer.

When the invoice database window is open, I would like it to automatically update based on the record that is currently open in the customer info window. In essence, I'd be copying the customer ID # from its field in the customer info database, into a field in the invoice window, causing the appropriately related information to appear on the invoice.

I just don't know what script commands to use to do this - please help!

Thanks everyone,

Jeff

[-Queue-]

Well, it won't automatically update; you'll have to script that. From your Customer table, you'll need a script like

If [Position(