AnsweredAssumed Answered

Lookup to existing data in related table and add new values to this table

Question asked by cater on Feb 20, 2019
Latest reply on Feb 24, 2019 by Philip.Wilson-esristaff

Is it possible to have a select_one field that instead of having the choices in the xls, references a field in a related table?  I have a survey that is used to do property inspections. It is a feature service hosted on our SDE with a number of related tables, one being Contacts and the relationship to this table is one to many.

 We have 5000+ contact names in our contacts table.  Ideally we would like the inspector to be able to look-up this table and if the name already exists select it in the field for Contact Name, but if it does not exist, be able to create a new contact name record.

I have looked at the PullData function and thought about having the contact names stored in the media file, but this also requires having all of the contact names listed in the Choices worksheet and the select_one field does not allow for new values to be added. 

Any suggestions as to how I could get around this problem would be greatly appreciated.