Ok, am doing that now. Although I'm already seeing problems with this! The following collumns are supposed to be populated with a combo box. I don't know what I've done wrong but there isn't even a drop-down menu and I can only enter numbers (the ID number). I'm so frustrated. Everytime I think I'm getting somewhere something like this happens. It works on my form though? So strange.
ClientID, ProjectStatusID, Theme, MRType, Methodology1, Methodology2.... it seems all of the collumns that are linked to another table are wrong.
I've tried to put in two records and it won't let me complete the second because it says
I'm not sure what I've done wrong because I thought it was alright in my form.... hmmmm