C
Christopher W via AccessMonster.com
My database is designed to store valuation data of assets one asset can have
a number of valuations. In order to store several valuations for a single
asset I have created a separate table from that of the asset/transaction
table. The asset transaction table contains data such as manufacturer,
generic asset name, model, serial number etc. The cost table just contains
costing information.
In the asset table I have included a subform to allow for the entering in of
a new asset. My problem begins when I require the transaction id to be
included in the subform without having to either manually enter it or save
the transaction form to the transaction table and then enter the costing data
in. I need it to just be included automatically as this is obviously of
crucial importance that the cost information is attributed to an asset in the
transaction table. Effectively I would like it to act like a form going to a
single table. REMEBERING this is for data entry only another form will be
designed to look up assets and add new valuation data.
If someone could please help me that would be fantastic!!!!!
a number of valuations. In order to store several valuations for a single
asset I have created a separate table from that of the asset/transaction
table. The asset transaction table contains data such as manufacturer,
generic asset name, model, serial number etc. The cost table just contains
costing information.
In the asset table I have included a subform to allow for the entering in of
a new asset. My problem begins when I require the transaction id to be
included in the subform without having to either manually enter it or save
the transaction form to the transaction table and then enter the costing data
in. I need it to just be included automatically as this is obviously of
crucial importance that the cost information is attributed to an asset in the
transaction table. Effectively I would like it to act like a form going to a
single table. REMEBERING this is for data entry only another form will be
designed to look up assets and add new valuation data.
If someone could please help me that would be fantastic!!!!!