I have an application I am developing that has nested lookup fields; i.e. I have lookup fields in a form that allow users to add new entries to the form that is being looked up and there are also more lookup fields for yet more forms in these lookups.
The problem is when I add a new entry for a form via this method it is not updated immediately so that I can select it as an option from the drop down lookup list.
Specifically, I have a PERMIT form that needs to have a SITE attached to it. From the PERMIT form I have a SITE lookup which users are also able to add sites to if it is not in the lookup list. When trying to add a new entry to SITE in this manner a user will need to have an ISLAND attached to the SITE. So, the user will need to lookup an ISLAND and perhaps add a new entry to ISLAND via the lookup, and so and so forth... Hence, the nested "add a new entry lookup" concept.
As I stated before, these fields that I am using to do the lookup are not populating when I enter the information. So, when I enter a new ISLAND via the add new entry in the lookup field for SITE the ISLAND entry I just entered is not available for selection in the lookup field for ISLAND in SITE. Instead I must close out of the original form that I was doing the lookup in and then reopen the form before the new entry will show up in the drop-down list. I do however get a blank line entry without any data in it where the new entry should be in the drop-down list. Needless to say, this is very clunky.
The caveat here is that the field I am using for the lookup is a field that has data concatenated from other fields in that table so it can be used as a unique identifier for the lookup.
I'm sure the right script can solve this issue, but I am unable, after much effort has been expended, to figure this out on my own. Any help you can give me would be appreciated.
Thank you very much in advance.