Hello,
I am designing a website using an access database as a backend, and have come up with this problem.

Table 1: Data with a CategoryID Referencing Table 2
Table 2: CategoryID; Category

Some of the Table 1 data references several categories in Table 2, If I can setup multiple referenced to the category this will save repeatitive data entry. Any suggestions would be greatly appreciated.

Thank You
Mike

What you're referring to is a many-to-many relationship (http://articles.techrepublic.com.com/5100-10878_11-5285168.html). You'll need to create a third table (child or associate table) to resolve the problem.

Cheers,

you are spot on, I just came to the came conclusion. As usual hoping someone had thought of an easy way out.

Thanks