Search results

Thank you...I went in and renamed all the tables and set autonumber for PK. Just as an FYI, when I tried the snippet of code posted above (before table name changes), it gave me a syntax error in FROM. Also, the error I received originally was the ambiguous join error, not definition...

Thank you, I do have the "Program Name" as the PK for the Program List table and it is a FK in the Program Notes table. However, I get the ambiguous joins error when I try to combine them through a query. This is what the two tables look like: Program List Table: Program Name - Text (PK)...

Hi, I am a bit of a novice to Access, so please forgive me ahead of time. I have scoured the internet looking for a solution to my problem and I can't seem to find one (or at the very least I do not understand it if I see it). I have several tables that I need to join together to create a...