I’m creating a golf score db to keep track of my rounds of golf. I have these tables:
tblCourseInfo general course info(name, address, phoe, etc)
tblCourseHoleDetail detailed hole information for the golf courses(hole number, par, distance, etc.)
tblGolfer Golfer information(name, address phone, etc.)
tblRound holds(roundid, date, courseid, golferid)
tblRoundDetail holds score details(hole score, # putts, Green in reglation, etc)
My problem is how to update the tblRoundDetail with the information entered in the form. I know this can be accomplished easier if I use datasheet or continuous form for a sub form, but I want to create a form that resembles the golf score card.
This the way I would like the form to work.
1. select golfer from combobox
2. select course from combobox (this would update unbound controls with records related to the golf course holes on the table- par rating, hole distance, etc.
3. enter date
4. then enter score details
I'm doing this in access 2003
Thanks in advance