AnsweredAssumed Answered

Using Find to Attach Customer to Request

Question asked by AmandaO'Connor on Aug 26, 2013
Latest reply on Aug 27, 2013 by philmodjunk

Title

Using Find to Attach Customer to Request

Post

     Hello,

     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

Outcomes