February 9, 200620 yr I have a layout with a pop-up menu based on data from another table (tblCCadd: containing company name/address etc) When the user selects the company name from the pop-up menu I want to insert the company address into an address field on my layout (this field is in linked to a different table) Must also be able to manually enter an address (not just bound to info in the address table) (hope that I’m making sense?) Thanks John Edited February 10, 200620 yr by Guest
February 10, 200620 yr I think what you are looking for is a lookup. This is the method used for an invoices table. When you enter or select a match field value the lookup places your desired result in your field. John
February 10, 200620 yr Author Thank John! I'm still not sure how to do that, but I'll get my head into the FM help and see if I can manage to do it. Cheers! John
Create an account or sign in to comment