4isteam
asked on
My round of golf
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good luck. (read: I don't know how you can do this) Perhaps Crystal Reports?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sounds fair.
ASKER
I know its easier to do it putting the holes up to down but thats not how a golf score card goes and thats what i'm trying to accomplish if possible.