Database problem (using Ultradev)

[Jason Walter]

I'm working on a site for a local Home Builders Assc.
They had some old DOS program for their accounting. I was able to convert
the database to an access file.

I hooked it up in MX and I have it online.
I can search for members by name. Now I want to add a category search.
I plan to create a drop down box with 12 categories. I created a new table
for the categories and I'll build the relationship by the members account
number.

The question is how can a member have more than 1 category? How do I set the
tables up for this?

Thanks
Jason

 

[Lynn Trapp]

tblMembers
MemberID PK
LName
FName
-- other member related fields

tblMemberCategories
CategoryID PK
MemberID FK
CategoryName
-- Other category related fields

 

[Jason]

Can you expand on that a bit? As I understand it I create a table for
the categories with a ID which will be the Primary key. Then within
that table I create all of the Category names. Also, in that table I
have a MemberID which is linked in a relationship to the memberID on
the member table. What is "FK"?
Is this correct?

Thanks
jason