I am trying to publish my database to our sharepoint and it tells me the relationships between my tables and the main table have error ACCWeb105016 for all which is: relatationships that are not associated with a web-compatible lookup are incompatible with the web.
I am not sure I understand what it means because my tables are like this:
Main: MID YR MTH PROG BUS CONTACT FREQ ST_CD LOB PROD COMM COMM_TYPE
YR_table: yr_id yr
mth_table: mth_id mth
prog: prog_id prog prog_desc
bus: busid bus bus_desc
contact: contactID contact phone email
freq: freqID freq
state: st_id st_cd
lob: lob_id lob lob_desc
prod: prod_id prod prod_desc
comm: comm_id comm_lvl comm_desc
communication: commID comm_type comm_desc
there are other columns distinct to the main table.
I join yr in yr_table to yr in the main table. this is because the main table is filled in as a data entry form is used to populate data into this table using the data in the tables to allow the user a selection of information. I have built my relationships in Access and now confused as to why I would get this error.
Do I need to change the relationship from equal to a left join? It does not say one-to-many in the relationship type, it says indeterminate.