OK, I got my junction table completed, and it's stupid enough that I should have thought of it myself. :blush:

Access 2007 DOES let you create a composite PK. ...

Thanks, Paul, I'll look for that - that isn't something my searches in Access help have turned up so far...

Yes, that is where I'm having issues. Access 2007 doesn't let me highlight 2 columns at once, I've tried several times. I'll try editing the PK in the index...

Yes, I understand that I need a PK composed of 2 fields, each of which is an FK for another table. But my question is: in MS Access,...

I've now read this thread twice, as I'm building a new relational database and have a couple of instances where I need to create such a table. I understand...

My database is now at compatibility level 90; I asked the ISP tech support if they could upgrade it and they did so. Apparently all I have to do...

That's useful to know, since I would like, eventually, to upgrade the site to DNN 5.X. I'll obviously have to upgrade the database then. I'm still torn whether...

My ISP tech support staff have just confirmed my suspicion that my database's compatibility level is 80; it was originally built on SQL Server 2000. If I read your...

That's my problem - at the moment I don't have a local copy of the database, because I don't have a functional SQL server on the laptop. I asked...

I am assuming your database is not in compatibility 80 if it is then you may want to move to at least 90 for 2005 before going 100 which is...

Thanks for the quick response, and I did consider going to SQL Server Express 2008 - my only reason not to would be that my production system is on SQL...