Web publishing won't show related fields from another DB
In one of my DBs I have related fields from another DB.
To my dismay I am discovering that the web published version of the DB won't show these fields. I get "<File Missing>" in the fields.
I know I can create another table and import all these records, but this data is to be shared across a few other DB's and I do not want to have multiple copies that I need to maintain and update.