I’ve done this before under Pan6, but can’t seem to get it to work in PanX: I have two related DBs. There are people who I’m entering in DB2 who can be looked up in DB1, and then info plugs in where it should. But if the person is not in DB1, I need to be able to enter their info in DB2. However, the lookup function is deleting hand-entered data as soon as I hit tab.
Well, that isn’t entirely accurate. The lookup is based on the email address, which then finds a form# and first and last names. If the person is not in DB1, then I need to put in a different form# (actually from the prior year’s DB, but it is hand entered) and their first and last names. When I paste the email address in, and hit tab, it wipes out the number I typed in Field1 (the form#) and goes to the firstname field; I enter the name, hit tab, and it goes to the latname field – but it does not wipe out the firstname! However, when I hit tab from the lastname field, it does wipe out the last name. I then have a name field which combines first and last. Now, if I go back to the email field and hit tab, it does wipe out the first name.
Simply put, is there a way to set it up so that lookup will not delete hand-entered data when the lookup “fails”?