Ok guys,
I have a database with about 7 join tables used to combined a set of locations with there staff members so its like:
tblSite
tblStaff
tblSiteStaff
With all the two FKs in tblSiteStaff etc.
This setup works just fine in my database before I upgrade to sql. After the move I am no longer able to add new records via my query (The NEW row is just not showing up).
If you view my samples please take a look at any of the frm's I did have to remove a lot of data but at least you can see how I have my forms setup.
I have a database with about 7 join tables used to combined a set of locations with there staff members so its like:
tblSite
tblStaff
tblSiteStaff
With all the two FKs in tblSiteStaff etc.
This setup works just fine in my database before I upgrade to sql. After the move I am no longer able to add new records via my query (The NEW row is just not showing up).
If you view my samples please take a look at any of the frm's I did have to remove a lot of data but at least you can see how I have my forms setup.
