Another scorecard question

[Fatti]

Below is what I am trying to achieve but not sure of the best way to go about it.





My previous question was about Combo boxes but what I would like is the whole thing in a datasheet format but not sure if I can do combo boxes into a datasheet if you get my drift?

Given what I want to achieve above am I heading down the right path or is there a better way to do it?

I guess im after some design guidance for now (technical questions will most definitely come later).

[June7]

Yes, Datasheet view can have comboboxes.

Having multiple similar named fields is often a clue that data is not fully normalized but this might not be bad. Depends on what analysis you want to do with the data. Normalizing data can be a balancing act between ease of data entry and ease of data output.

[Fatti]

I think the normalisation is ok. Ive got a Competitor table with all of the competitor details and a competition table with only competitor_ID as a column. The name column in this datasheet is linked via competitor_ID.

So what ive done is create a datasheet and converted the first column to a combo box then built a query to bring back the last and first name.

Only thing is when I select someone in the first box it populates the rest of the boxes in that column.

This guy had the same problem but im not understanding the solution.

https://www.accessforums.net/access/...box-19950.html

[June7]

By 'create a datasheet' you mean you have built a form? The form has a RecordSource? The comboboxes are bound to fields of the RecordSource? The advice given in the other thread applies to your situation. You must bind this control to competitor_ID field of form's RecordSource. You want to save the competitor ID, not the actual name. The combobox should be multi-column. Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the ones about comboboxes in the section AccessForms:ControlBasics.

[Fatti]

By 'create a datasheet' you mean you have built a form? The form has a RecordSource? The comboboxes are bound to fields of the RecordSource? The advice given in the other thread applies to your situation. You must bind this control to competitor_ID field of form's RecordSource. You want to save the competitor ID, not the actual name. The combobox should be multi-column. Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the ones about comboboxes in the section AccessForms:ControlBasics.

Yes sorry I have built a form with a datasheet. Even though it had a recordsource (the table it was built on), I didnt bind it to the id column of that table.

All fixed now. Thanks very much for your time and info.