accessdummy
Registered User.
- Local time
- Today, 15:00
- Joined
- Sep 7, 2003
- Messages
- 44
Hi,
I've a problem here regarding the use of continuous form and checkboxes.
Scenerio: 20 people receiving apples, 10 receiving pears, 20 receiving oranges.
So what I want in the form is that I can select the fruit type. Then it will trigger all the people's name in my database with a check box against their name. Then I can check or uncheck (update status).
==============================================
Table design::
I have created a many-to-many relationship between people and fruits
Question:
1) How do I use combo boxes to trigger the use of continuous form to display each individual name + a check box by their names for updating purposes?
2) How should I go about adding records into my many-to-many table?
==============================================
I've a problem here regarding the use of continuous form and checkboxes.
Scenerio: 20 people receiving apples, 10 receiving pears, 20 receiving oranges.
So what I want in the form is that I can select the fruit type. Then it will trigger all the people's name in my database with a check box against their name. Then I can check or uncheck (update status).
==============================================
Table design::
I have created a many-to-many relationship between people and fruits
Question:
1) How do I use combo boxes to trigger the use of continuous form to display each individual name + a check box by their names for updating purposes?
2) How should I go about adding records into my many-to-many table?
==============================================
