Hello,

I just want to check if there is a better way to do this

i have 1 table called Categories, and 1 table called parts. I want to have another table called partcat that will list all the parts and what categories they are in.

I want to make the parts available in multiple categories.

This means i would have multiple field names in the partcat table with the same name with increment of 1 for example partcat1 and partcat2 and partcat3.

As i would be creating a relationship for each instance, as the part could be in many categories.

This way seems messy and could get confusing

Is there a better way to do this in access?

Any help would be much appreciated