Hi, I have the need to autofill (select a default) for a lookup table type question based on two selected options above, not just one.
I have the following fields above - Start Location, End Location. These are lookup tables with ids.
I also have a table Routes that has Start Location foreign key and End Location foreign key in it, and also a code field. There may or may not be a route for a certain combination of a start and end location. If there is, the code from the route should be used as the default.
So, I want to select a default code based on the selection of both Start Location and End Location.
Is there a way to do this? Perhaps there is a way to provide a custom autofill query?
Thank you!
