Hello,

I have a customer/product database with a layout setup in form view that has customer’s information including address & image. I would like to have some type of feature set up when a new record is selected, and I enter the customer’s first and last name, their address & image will auto fill in the appropriate fields, if this information existed prior. Could anyone tell me how to accomplish this task with detailed instructions?

What is the relationship between a customer and a product?

Typically, customers have invoices and invoices have line items. The line item is related to the products table by product ID.

Each customers information is created ONCE and related to an other "form."

Have a look at some of the templates that come with Filemaker (such as any to do with Invoices).

Thank you for your help Consultant, I might have not made myself clear with the example I posted. I have a form that contains various business names & address info as well as customer information on the same table. I did a self-join relationship and it solved my problem. I enter a new record, enter the business name in the business name field and the business address + phone number and other related info auto populates in the associated fields. I did the same thing for the customer. My self-join relationships are based on the business name and customer name.

Self-join.pdfI ran into a problem with the self-join. I soon realized that I could not enter new data into the related self join fields. Please view the attached pdf file to view the screenshots of involved fields and relationships. If anyone knows how I can accomplish this task, please let me know and provide me with detailed instructions. Thank you.Self-join.pdf