Update Query

[pl456]

Hi everyone, first time on this site, hope someone can help. I have put it under this title but it may not be possible by this method.

I have a problem that I can not get my head around, it is a quiz database that has a table of questions and another table of venues.

How can I stop the same question being asked at different venues but not remove the question for other venues that have not yet been asked that question?

 

[neileg]

Create a junction table that holds the ID of the question and the ID of the venue. Apply a multi field index to the two ID fields and set this to no duplicates.

 

[pl456]

I had forgotten about using 2 fields as the PK. I think I may have been looking at the problem too closely to see the answer.

Thanks