Multiple Categories in a Table

[mikesd]

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

 

[ConneXionLost]

What you're referring to is a many-to-many relationship. You'll need to create a third table (child or associate table) to resolve the problem.

Cheers,

 

[mikesd]

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

Thanks