Link to home
Start Free TrialLog in
Avatar of 4isteam
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
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 4isteam
4isteam

ASKER

thanks for your response jimhorn,
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.
Good luck. (read:  I don't know how you can do this)  Perhaps Crystal Reports?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sounds fair.