Please help beginner with football d/b design

[YIMan]

For a couple of years now I have been keeping a spreadsheet record of UK football match results and statistics - I use this as the basis for gambling on future matches. I now want to migrate this information into a database so that

1) It is much easier to enter the new data(via picklists)
2) I can generate reports on particular teams to help me on future betting decisions

Being almost completely new to Access I am struggling with the design. The information I'm capturing is:
Match Date
Competition(table including five)
Home team/away team(table including many depending on competition)
Home formation/away formation(table with standard list)
Home goals/away goals(numerical)
Home corners/away corners(numerical)
Home bookings/away bookings(Numerical)
Referee(from a standard list)
All the above is in a match results records table with relationships to each data element table.

For the form for data entry, I want pick lists for all non-numerical values - eg team, formation etc. I would like to get a little cleverer and for the team pick list to only contain teams that are in the competition I've selected(eg Uk or European).

I've created some tables and relationships, but when I create a simple form with combo-list boxes, the list itself comes up blank even though I've linked the field to a particular table of options(eg a competitions table).

Can anyone help on suggestions for the overall design(should I have separate match results tables and team tables for each competition?) and with this particular combo-box problem please?

 

[L'apprentis]

Well, It's going to be a bit more difficult than you expect.
I advise you to do a bit of reading and use the search option of this forum; it did help me quite a lot.
For the combobox you should look for 'cascading comboboxe', you have a very cool tutorial in the sample database section.

For your question, you can have an unbound combo box that can lookup a table you can do that automaticly by using the Wizard: on the tool box toolbar before building your combobox or listbox click the control wizard,then click combo box and finally click on the form; you just have to follow the instruction to get your combobox working....

 

[statsman]

I've had a look at your comments and the only reason I feel you're getting a blank combo box is because you have set up the combo incorrectly.

First of all, when you created the combo box, did the combo box wizard assist you? If not, make sure your wizards are turned on.

Delete the current "Competition" combo box from your form and try again using the wizard. From your comments, you just want the combo box to enter data on the form. Follow these steps:
- Click on Combo box on the toolbox bar. The wizard should start after you have placed the combo box on the form.
- Select "Look up values in a table or query"
- Select the table that contains the data you want.
- Select the field(s) in the table that you want displayed in the combo box.
- Set the width of the combo box
- Store the data in which field in the form's underlying table
- Enter a name for the combo box label.

 

[YIMan]

You're right - got it working now - thankyou!

Thanks for the tips on cascading combo-boxes too - will give it a go!