MS Access query help

[davestar_delux]

Hey I can't seem to get my head around this query I'm trying to do.

I have 3 tables like so:

[courses]
courseIDPK
coursename
signUps

[users]
usernamePK
password
signUps

[usercourses]
userCourseIDPK
userName
CourseID

I want a query that will check if users.signUps is less than 2, courses.signUps is less than 15 and there isn't a record in usercourses with the username and courseID provided already.

Then I want to add that record and add 1 to both users.signUps and courses.signUps.

Is this possible?

 

[davestar_delux]

To be honest I solved things myself before anyone replied and i've been at work all day so not had a chance to read any replies on here.

Thanks to those that posted something constructive though.