My tables look like this (abbreviated):
TblRegistration
RegistrationID
MemberID
FeeID
TblFee
FeeID
TypeID
OptionID
Fee
FeeID in TblRegistration is joined to FeeID in TblFee.
I would like a continuous form containing MemberID, FeeID from TblRegistration,
TypeID and OptionID where I can enter TypeID and OptionID and FeeID from
TblRegistration is automatically entered. How do I set this up?
Thanks fo all responses!
Tom