Greetings All,
I've got a problem with a lookup field not always autofilling in the other fields.
I have a table (Actually a view that pulls data from a linked database on another server) with order information that I use in a lookup field to autofill in the information into a form. The order number (usually scanned in from a barcode) is used in a lookup field and that autofills all the order info into several read only text fields and one quantity field that is editable so the user can change the quantity if needed.
This works about 95% of the time. Other times, it does not autofill the fields at all. The strange thing is that when I go to edit one of these empty records, I can delete the order number from the lookup field and as soon as tab to the quantity field, the autofill seems to trigger and populate the other fields with the correct data, even tho the order number is now blank. I've attached a couple of screenshots showing before and after on the edit page.
Edit Page:
After deleting the Order number on the Edit Page, Note that the autofill was triggered:
One the edit page, it seems like the only way to get the autofill to trigger again, is to enter a different order number, tab, go back and delete the order number and type it again. Just deleting one or two of the originally order numbers and re-typing them, isn't enough to trigger the autofill.
This doesn't happen all the time, but it happens enough that I'm getting several records that are missing information in the database. Anyone else have a problem similar or have an idea on how to fix? Is there a timeout where the autofill doesn't wait long enough for the lookup query to return data and fills in empty data?
Anyone have any suggestions?
Thank you kindly,
Chris
