Lookup Not Working With Internet Web Publishing
Ok, so the Knowledge Base article below obviously means to do this on the local machine (not in IWP) because there is no "File" menu or "Submit" button on the browser (IWP).
So, on the local machine, I open the file, click "File/Manage/Database" (there is no "Define > Database"
NOW, I check Prohibit modification of value during auto entry. The only option here is to "Save Layout" (there is no "submit" button).
I go to my browser via the internet (IWP) and go to the database. I enter the UNIT ID and hit "Tab" but nothing fills in. It only tabs to the next empty field.
Lookups do not work properly in Instant Web Publishing (IWP) with multi-file solutions.
To resolve this issue:
- With the database open, choose File menu > Define > Database.
- In the Define Database dialog box, click the Fields tab.
- Double click on the lookup field.
- In the Options for Field dialog box, click the Auto-Enter tab, check the checkbox at the bottom that states Prohibit modification of value during auto entry.
The lookups will now work in IWP. The only draw back with this workaround is that the fields will be unmodifiable. If its necessary for the user to edit these fields a second group of fields will have to be created to act as submission fields. Create a new layout with these fields for data entry. Use a script to set the lookup fields to the data in the entry fields.
Note: that a lookup field will only be updated via IWP after you click on the "Submit" button to commit the record.