Hello, here's my problem, and I'm not too sure what the solution would be.
I'm creating a trade directory, and I would like the business on this directory to be listed under more than one category. I currently have my table setup to accept one (one-to-many relationship) category, but when I want to add another category (located in another field) it won't display both.
I'm not sure I fully understand where you are up to but here's what I think you are trying to say.
You have a table (lets call it tblCustomer) which contains a list of customers and you have a couple of fields which allow you to link to the business category. The customer number is the primary key. So your table looks something like this:
Then CustomerNo in tblCustCat is related to CustomerNo in tblCustomer and Cat_No in tblCustCat is related to Cat_No in tblCategory. In this design it is very easy to create the querys/reports you are looking for.
One point to note. In the form design you will have a main form and a sub-form. E.g. the main form could be customer and the sub-form will allow multiple entries of Cat_No for that customer.