Show values in fields related to choice in autocomplete dropdownlist

[filemakinit]

Using FileMaker Pro 13

I have a view in a SQL Server 2008 server that provides customer id (unique identifier), first name, last name, and full name.

I have two tables in my Filemaker Pro database.  One represents the external SQL view and the other is a local "customer sign in" table made up up customer id, customer first name and customer last name - and a relation to the table representing the view.

 

I have a layout where the "Enter Name:" entry is a dropdownlist with autocomplete using a valuelist that pulls the fullname from the view.

 

The autocomplete is working well.  What I'd like to do is add "First Name" and "Last Name" fields to the layout and have them populate with the first and last name of the selection in the fullname (either during entry or tab out is fine).

 

Is there a way to do this in FileMaker Pro?

 

Thanks

[mikemccabe29]

What if you set those as calculations using the let statement like this?

 

Name_First = 

    Let ( trigger = fullname ;  related_SQL_table::First_Name )

 

Name_Last = 

    Let ( trigger = fullname ;  related_SQL_table::Last_Name )

 

 

When "fullname" changes, the Let statement gets "triggered."