AnsweredAssumed Answered

Relationships, Lookups, and Storing the record ID From a lookup

Question asked by alanfair on Sep 1, 2012
Latest reply on Sep 5, 2012 by alanfair

Title

Relationships, Lookups, and Storing the record ID From a lookup

Post

I am new to filemaker, and perhaps i am missing something, but cannot get this to work.  Something i do in access without any issue.

Keeping the example simple.  Two tables, a) Customers Details, b) invoice details.

The customer table,  - each record has a unique number in the field C_ID , and the name of the customer in the Field C_NAME

Invoice table - Key fields are I_ID - unique record no, I_Details = some invoice text,  I_C_ID = number of customer record to which ir relates.

Have defined a relationship between C_ID and I_C_ID

SO WHAT DO I WANT TO DO !

When entering an invoice on my Invoice layout screen , I want a drop down list of customer names, to allow selection of the customer, but i want the customers ID (C_ID) stored in the invoice record in the field I_C_ID. - Cant seem to do this.

Can store the name but i need to store the link.

Can any of you Pro's Help, Thanks

Outcomes