access2010
Registered User.
- Local time
- Yesterday, 21:55
- Joined
- Dec 26, 2009
- Messages
- 1,023
Could I please receive your suggestion as to why our database is not producing the results we would like to receive, linking two tables by Investmentl_ID.
We have a database containing about 1,000 Equities which we will be following.
===
Each equity has about 20 different criteria’s for research.
Should we create one huge table of 1,000 Equities with 20 different fields, or tables that are linked as below?
===
Table = Name_Stock_T = which would hold the Equity’s Code and Stock Name
Table = Symbol_Stock_T = which would hold the Equities Research and this table would be linked by = Symbol_Stock
or
Table = Name_Stock_T = which would hold the Equity’s Code and Stock Name
Table = ID_Stock_T = which would hold the Equities Research and this table would be linked by = Investmentl_ID
===
Your suggestion will be appreciated on which of the 3 choices will be better.
Thank you,
Nicole
We have a database containing about 1,000 Equities which we will be following.
===
Each equity has about 20 different criteria’s for research.
Should we create one huge table of 1,000 Equities with 20 different fields, or tables that are linked as below?
===
Table = Name_Stock_T = which would hold the Equity’s Code and Stock Name
Table = Symbol_Stock_T = which would hold the Equities Research and this table would be linked by = Symbol_Stock
or
Table = Name_Stock_T = which would hold the Equity’s Code and Stock Name
Table = ID_Stock_T = which would hold the Equities Research and this table would be linked by = Investmentl_ID
===
Your suggestion will be appreciated on which of the 3 choices will be better.
Thank you,
Nicole