I have a need to create these two tables:
Scheme 1:
Table A contains fields: Key / Element name / atomic weight / etc...
Table B contains fields: key / Date (daily) / Gold price / Fe price / other commodity price of the day - all material i try to track..
Basically, Table B is the daily price of [Element] field of Table A. So how can I relate table A and B ---- I need use Value of the [Key] of Table A as element field of Table B. When I add new commodity to table A, would like access automatically add a corresponding field in table B and start to track the price of that commodity.
Is it possible in access? Is there a name for this kind of implementation?
Scheme 1:
Table A contains fields: Key / Element name / atomic weight / etc...
Table B contains fields: key / Date (daily) / Gold price / Fe price / other commodity price of the day - all material i try to track..
Basically, Table B is the daily price of [Element] field of Table A. So how can I relate table A and B ---- I need use Value of the [Key] of Table A as element field of Table B. When I add new commodity to table A, would like access automatically add a corresponding field in table B and start to track the price of that commodity.
Is it possible in access? Is there a name for this kind of implementation?
