Confussed

  • Thread starter Thread starter John Kirkman
  • Start date Start date
J

John Kirkman

Hello All,

I am trying to record attendance for an event and have set up the following
tables, so for example we would have lunch, dinner each at different prices
for each event.

tblEvent
EventNo-(Autonumber)
EventDate

tblEventDetails
EventDetailNo(Autonumber)
EventNo (Foreign Key)
Amount

Now to record the resiverations I have create the following tables. When I
make a "Reservation" I populate the tblReserveDetail by code with as many
records as there are Event Details for that event.

tblReserve
ReserveNo (Autonumber)
MemberNo
SpecialNeeds
etc.
tblReserveDetail
ReserveNo (Foreign Key)
EventDetailNo (Foreign Key to tblEventDetail)
NumberEating

What I thought I could do is create a query linking tblEventDetail and
tblReserveDetail using EventDetailNo, then I could get total by NumberEating
* tblEventDetail.amount. But with the two tables linked, I can not change
NumberEating? I am really confussed and would appreciate any help.

Regards,

John
 
Hello,

I solved my own problem. I had forgoten to make tblEventDetail.EventDetailNo
a primary key!

John
 
Back
Top