N00B question - How do I have multiple fields populate from MySQL when one field is populated?
I'm pretty newb at Filemaker, so I hope you'll forgive if this is a silly question.
I've just figured out how to create a drop down list that is pulled from a MySQL database via ODBC. But I can't seem to find out how to have other fields populate from data in the rest of the record. For instance...
I have a series of people with records in MySQL. I need to check in and check out equipment to these different people. Using the Inventory starter database as a base, I've figured out how to pull a given persons first name from MySQL via a dropdown list, but I cannot for the life of me figure out how to get additional information to populate based on the value in the dropdown. I'm trying to get their last name, phone number, email address etc. to automagically appear once the first name is populated.
Can someone give me a big red pointer sign --->> LOOK HERE! or somesuch?