S
SAm
Hi
i am working on database which will keep track of all computers, servers,
printers etc.. purchased. i created a table which has all the computer model
numbers with all the specs as fields. i have an ordrer form which records an
order. there are two subforms. one is the payments subform, which works fine.
then i have an asset form (continuous). the assset form records the assetID
and some other info about the asset (like location, user, IPAddress etc.)
after the model number is selected, i have a sub that runs and finds the
model number in my template table, and records all the specs in a table
related to the assset table. its the assset description table. if my sub
finds an entry with AssetID and a different model number, it deletes the old
entry and adds the new entry. i record to the asset description table using
an append query. the sub is set up to work on exit from the pulldown menu of
the modelnumber.
the sub works fine, however, if i click on another record (its a continuous
form) or if i close the form or if i click on top portion of the form, then
its fine. if i click on anotehr field of the same record, then an error
message comes up that there is a parent table (AssetTbl) that is missing. how
do i fix this issue? also, do you have a better way to design this database?
thanks,
sam
i am working on database which will keep track of all computers, servers,
printers etc.. purchased. i created a table which has all the computer model
numbers with all the specs as fields. i have an ordrer form which records an
order. there are two subforms. one is the payments subform, which works fine.
then i have an asset form (continuous). the assset form records the assetID
and some other info about the asset (like location, user, IPAddress etc.)
after the model number is selected, i have a sub that runs and finds the
model number in my template table, and records all the specs in a table
related to the assset table. its the assset description table. if my sub
finds an entry with AssetID and a different model number, it deletes the old
entry and adds the new entry. i record to the asset description table using
an append query. the sub is set up to work on exit from the pulldown menu of
the modelnumber.
the sub works fine, however, if i click on another record (its a continuous
form) or if i close the form or if i click on top portion of the form, then
its fine. if i click on anotehr field of the same record, then an error
message comes up that there is a parent table (AssetTbl) that is missing. how
do i fix this issue? also, do you have a better way to design this database?
thanks,
sam