Choosing a table to update in a form

[Shooting Star]

Hi,

I am making a statistics database for my Computing Coursework about a sports team. I have separate tables for different players' stats.

I would like to have a form where I can add statistics for the players. Is it possible to have a dropdown box within this form which has a list of all the player tables, and then whichever table I select from this list/dropdown box, the form adds data into that specific table?

Thanks, and sorry if this seems quite a novice question - databases aren't really my forte!
Steven

 

[rainman89]

"I am making a statistics database for my Computing Coursework about a sports team. I have separate tables for different players' stats."

When you say this... do you mean that you have a different table for each player?

 

[Shooting Star]

Yep, that's right. Sorry for any confusion!

 

[boblarson]

Sorry to break the news to you, but your data structure is flawed and not normalized.

You should not have separate tables for different players' stats.

You need to NORMALIZE your structure. See here for more about Normalization.

 

[boblarson]

"I am making a statistics database for my Computing Coursework about a sports team. I have separate tables for different players' stats."

When you say this... do you mean that you have a different table for each player?

HEY! You beat me Ray

 

[Shooting Star]

Okay. Should I have one central table with the stats in for every player then?

 

[boblarson]

Okay. Should I have one central table with the stats in for every player then?

Read the article in the link and see if that helps to clarify it a bit. It isn't that you have ONE table, necessarily. It is you have the APPROPRIATE table or tables. It really depends on the data you are going to be storing and the "business process" that you are following.

 

[rainman89]

HEY! You beat me Ray

You are getting slow in your old age...

 

[boblarson]

You are getting slow in your old age...

Apparently.