AnsweredAssumed Answered

search dropdown list

Question asked by kentanderson on Oct 24, 2016
Latest reply on Oct 24, 2016 by kentanderson

I have two separate tables.  One called Passengers and its only function is to hold passenger names and a calculation to add first and last name.  In my main table I have several passenger fields.  What I want to do is have the passenger fields on the main table contain a drop down with a value list pointing to the passenger table.  I have been abel to achieve that, now what I want is to be able to start typing a name "Do" For say Doe Jane and the drop down scroll automatically to the best fit.  That box is greyed out on the inspector, Im assuming its because the tables are unrelated.  I defiantly want this to stay a value list incase someone deletes a old passenger from the list it still shows in a previous table.  Is there a way I can make like a generic relationship to achieve this or ????    Im open to any new suggestions or ideas.  Thanks in advance