Complicated Form

[DBA-Meister]

I have a fully normalized (TNF) database, which you can examine here:

https://docs.google.com/open?id=0BzEN-8iqecFtX1A1SFd4UzdyTlk

I need to create a form to enter scores into the scores table. I would like the user to click on a row item from the MatchDates table. Then use the WeekNmbr from that row to find all rows for that weeknmbr in the matchups table. Use the two team id's from each row to find the team names in the teams tables. Then, for each matchup, list the two teams beside each other. Beside each team, I need the names of the four players from that team (from the players table), and then three blank boxes for each player where a score could be entered into the scores table. Ideally would be able to enter all 24 scores for each matchup (paired-teams) on the same page.



Can I do all this in the form or should I create some queries to minimize the number of objects?

[June7]

Need to create records in the table then open or requery the form to display those records. I would use VBA code to execute SQL actions that INSERT records to table. This is not a simple process to automate.

Review
https://www.accessforums.net/access/...orm-25302.html
https://www.accessforums.net/program...nts-26223.html

[istari88]

I see you have already made some queries. Any used for this form already?

[DBA-Meister]

Need to create records in the table then open or requery the form to display those records. I would use VBA code to execute SQL actions that INSERT records to table. This is not a simple process to automate.

Review
https://www.accessforums.net/access/...orm-25302.html
https://www.accessforums.net/program...nts-26223.html

I don't understand why I would need to create records and requery to display those values. I only want to populate one table (the scores table) and only for one week (at a time). I just need to use all the other tables to get the correct team iD's, player ID's and week numbers for this table.

[DBA-Meister]

The web site http://www.datapigtechnologies.com/f...combobox1.html has great tutorials about the use of combo boxes. It will probably take me (part time) a few weeks to make it work, but I'm pretty sure combo boxes are going to solve my problems. I will repost if I need further help and will close this issue with an update when I get it done. Thx for all the suggestions.

[June7]

I misread your original post. Possibly because already dealt with other posters who did want to create a set of records and present them to user for completion with additional data. Yes, comboboxes will probably accomplish what you want and DataPig does have great tutorials.