Trying to figure how to allow user to jump from a main entry form to another form to enter new data.
I have a user entry form that uses a ValidIf to get a list of vendors from a separate vendor table. If the vendor is not in the vendor table I would like to allow the user to jump to the vendor form to enter the new info and then come back to the primary form, select the new vendor, and continue with data entry.
I tried creating a new virtual column with a deep link, but that does not work.
Anyone able to suggest the best way to do this?