Choosing Multiple items from a Table

[gbs01]

I know this is simple but I'm unclear how to....
----------------------------

Have the following 2 tables:
------------------------------
tblBusinessAgreement
BusinessID
BusinessName
FeatureID (linked to tblFeatures)

tblFeatures
------------------------------
FeatureID
FeatureChosen (Yes/No field type)
FeatureDesc
FeaturePrice


On my Form, I need to use check boxes by each feature, allowing the user to "check" those features that apply.

Question is...
------------------------
1) How will my table know which features were checked for a particular business?

I'm unclear how my "design" will allow me to run a query & find the "features" that are checked for each business.


Thanks in advance,
jlig

 

[PHV]

I guess you need 3 tables:
tblBusiness
BusinessID
BusinessName

tblFeatures
FeatureID
FeatureDesc
FeaturePrice

tblAgreement
BusinessID (linked to tblBusiness)
FeatureID (linked to tblFeatures)
FeatureChosen (Yes/No field type)
with composite PrimaryKey on BusinessID + FeatureID

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[clearwave]

PHV, I'm sorry for not responding back on your post. I lost track of this one. I have moved forward a bit on this & my last post :

http://www.tek-tips.com/viewthread.cfm?qid=1130591&page=1

gives the full details. Do you see what I'm trying to do? Use a POP-UP form with check-boxes allowing a user to choose those that apply? To be honest this thing eludes me.

Thanks again,
jlig