Force data entry based on TWO combo boxes

[mgargUWBC]

I'm creating a database for tracking workshops that are sponsored by different groups. What I'm working on is a form in which I have 2 combo boxes (Personnel & Workshop). Users are able to pick any personnel and any workshop. When they have choosen the Personnel and the Workshop I need to fill in a Fee IF that Person is NOT part of a Group that is sponsoring the choosen Workshop and do nothing if they are part of a sponsoring Group. In my scheme - Groups sponsor Workshops and Personnel are part of Groups.

Basically my pseudocode is:
IF NOT(Personnel in SponsoringGroup) THEN
Fee = 175
END IF

My problem is the IN part above. Since SponsoringGroup is not necessarily a single group (groups can sponsor workshops together) that will end up being a list of all the SponsoringGroups. How do I find out if my Personnel is part of any ONE of those groups?

I would really appreciate any help or guidance offered.
THANKS!
Michelle

 

[Rolliee]

Michelle,

Why not tie the workshops to a form with the students as the subform to be added. I would also have a table that tied the students and workshops that would add the $$$.

 

[mgargUWBC]

Thanks Rolliee,

The problem is that anyone can take any workshop, but some people have to have the fee added (those people who are registering for a workshop that is NOT sponsored by their group). So I can't restrict who can register for a workshop. We need to have the fee automatically added (and non-removable) for those people registering for a workshop NOT sponsored by their group because some staff have been letting people into workshops without the fee. It has happened enough that it has become a financial problem.

Would your solution work for this?

Michelle

 

[Rolliee]

Michelle,

Yes, you use only the related data only to make charges. Those with the workshop ID and their ID on a record would not pay. If you wish a sample mdb, email and I will work one up and send you the sample and then post the code.

rollie@bwsys.net