Because I'm a novice, I can't reconcile a Recommendation to always avoid using Lookup Fields in Tables, and the Requirement to use Lookup Fields for a Published Access database. (Sources pasted below.)
If Lookup Fields in Tables are a bad idea, then does that mean using Access to publish a database to the web is a bad idea too?
RECOMMENDATION
Thou shalt abhor the use of "Lookup Fields" which art the creation of the Evil One.
The Evils of Lookup Fields in Tables
REQUIREMENT
ACCWeb105016 Relationships that are not associated with a valid lookup field are incompatible with the Web.
What it means The relationship is not supported by a lookup field, and is therefore not compatible with a web database.
What to do Create a lookup field between the related tables. Use the Lookup Wizard to create the lookup.
http://office.microsoft.com/en-us/ac...BMaccweb105016