Auto Complete

[FMDumbo]

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, 2006 by Guest

[flapjacks]

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

[FMDumbo]

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