Jump to content

Show values in fields related to choice in autocomplete dropdownlist


filemakinit

This topic is 3468 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

  • Newbies
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."
Link to comment
Share on other sites

This topic is 3468 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.