Web Compatibility Issues

browninaz

Ugly Data Hoarder
Local time
Today, 11:18
Joined
Oct 26, 2012
Messages
88
Hi everyone,

I am trying to create a db structure that will allow me to access my be from the cloud. I have run a compatibility check and fixed most of the issues, but the error that has me stumped is this:

ACCWeb105016
Error text 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.


I have been taught that lookups at the table level should be forbidden due to the fact that it prevents you from being able to query that field. How do I fix this issue without harming the integrity of my structure?

Thanks to all who know more than me.
 

Users who are viewing this thread

Back
Top Bottom