Using Find to Attach Customer to Request
This is my scenario.
I have 'Customers' table, with a PK as 'Customer ID'. This is a serialized auto-generated value. There are several demographic fields attached to the Customer.
I have 'Requests' table, with a PK as 'Request ID'. I want to attach the customer to the request. This can be a many to one relationship (many requests to one customer)
I don't want to use the "Value List" as I could potentially have hundreds of customers. I am looking for a button, to enter the find mode of the 'Customer' table, locate the customer, and select the customer, and the Customer ID value will auto-populate into "Customer" field in the 'Request' record I am creating... and based on the customer ID in the record, field such as phone and address will auto-fill.
Someone HELP! Please.
I'm using File Maker Pro 12