Design change

[Stephm]

Hi. I have:

tblEvent
EventVolunteerID
ContactID
VolunteerID
ShiftID

tblVolunteering
VolunteeringID
VolunteerDate

tblShifts (apoligize in advance for spelling errors!)
ShiftID
ITABucks

tblBucksMember
BucksMemberID
BucksID
BucksNumber

tblBucks
BucksID

One form allows user to setup the event (with org. info),
and assign shifts. Bucks (for volunteering) are assigned
at the shift level. Then on the Contact form, I have a
combo box that gives Date, Event and Org. And then user
chose Shift and then Bucks were assigned to the Contact.

I also had a form to assign "free form" Bucks when it was
more convenient not to assign a shift. These weren't
linked to an even/volunteer opportunity.

It was all very cool and worked well. But the user
doesn't want shifts or "free form" Bucks. But I still
need to assign Bucks. I want Bucks linked to
events/volunteer opportunities (in that I'd like to see
how many Bucks were assigned by Contact for each
event/volunteer opp) but I'd like the user to enter the
number of Bucks. So I'll get rid of tblShifts,
tblBucksMember and tblBucks.

How can I design this given tblEvent and tblVolunteering.

Thanks, Steph

 

[Stephm]

Amazingly, I figured this out! Steph