filling a field in a form from another app based on another selection within the form
I have a form which uses a text multiple choice field to look at aircraft stored in another app based on their tail number (like a serial number). I want another field on the same form to go look at the same app and return the aircraft type so that when I select an aircraft tail number it automatically fills in the type. I would rather not use a list stored in the table the form is on because aircraft change from time to time. Is there a way to do this that won't require saving after selecting the tail number?
