Filemaker Pro

[damo]

At work I am trying to set up a database using Filemaker Pro 6.5
I have a field which displays a Customers name, another with their Postal Address, and one with their Delivery Address.

I want to create a lookup, where by the user will just type in the first few letters of the customers name, then press enter, and the Customers Full Name will come up, along with their address's. I've tried using the help, with little success.

Any Suggestions??

[tikdoph]

Hopefully this link (http://www.filemaker.com/ti/106260.html) will be of some use and will get you on the right track.

The Support area on the vendor's website should be one of the first ports of call when looking for a solution. Good luck.

[damo]

Thanks for the help tikdoph, for any who are interested, this is the solution that I have implemented;

Attach a pop-up list to the customer field in the main db. For this list, use values from field "customer" from Customer details db.
Make a relationship between the 2 files, match Customer field from main db with the Customer field in Customer Details db.
In the main db layout, put the related fields such as address, etc. from this new relationship beneath the customer field with the pop-up list.
In browse mode, when entering a name in this field, the list will pop-up and go to the first matching customer name.
Selecting the name of your choice, will fill all the details in the related fields.

PS: when formatting the related fields, uncheck the option "Allow entry into field", so changes on addresses etc. can only be done in the Customers details db.