AnsweredAssumed Answered

Creating a relational table

Question asked by PeterW45 on Nov 3, 2018
Latest reply on Nov 8, 2018 by PeterW45

I went through the Filemaker Tutorial 201, Lesson 3 (Tables, Fields and Relationships - Tutorial 201 - FileMaker Custom App Academy ).

 

I then explored the resultant table. I made a new client and visit. In the visit table, I cannot enter the client name. I can only enter the Client ID. The Client ID is a rather awkward expression that is only practically handled by a cut and paste. Now this seems impractical as far as what I would expect someone entering the data. I can expect that one would know the client's name, but not their ID. How should this database be altered to allow the user to enter the client's name and have Filemaker return the Client ID?

Outcomes