December 3, 200421 yr Newbies 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
December 3, 200421 yr Well, it won't automatically update; you'll have to script that. From your Customer table, you'll need a script like If [Position(
Create an account or sign in to comment