saving record

[klp via AccessMonster.com]

I have a form that is based on a query, which has 2 tables in it.
tblCalibration & tblEquipment. I want the record to only save to
tblCalibration but it's saving to tblEquipment as well. Here is a little
scenario:

On my form, when you click new an custom auto number comes up in the CRID
field. Just beneath that I have an EQPID field, here you need to select the
eqp number to be associated with the CRID field. When I save I want it to
write all the information including the EQPID # back to tblCalibration but it
does not even save to that table, instead it writes back to tblEquipment. Why
is that? Even if I use tblEquipment for look up purposes it will still write
back to that table. For instance if I select and EQPID #, I want it to bring
up all associated data corresponding with that number. Which if I put logic
in for it to do that it will still save to tblEquipment.

any help please. Let me know if this information was confusing or you need
more. Thanks!
Kim P

 

[John W. Vinson]

I have a form that is based on a query, which has 2 tables in it.
tblCalibration & tblEquipment. I want the record to only save to
tblCalibration but it's saving to tblEquipment as well.

Of course. That's what you're asking it to do (by including both tables in the
query).

Consider using a Form based on tblEquipment, and a Subform based on
tblCalibration. Use the EQPID as the master/child link field.

 

[klp via AccessMonster.com]

Yep that crossed my mind too. I will work on that. Thank you!

 

[klp via AccessMonster.com]

Yep that crossed my mind too. I will work on that. Thank you!

 

[klp via AccessMonster.com]

Yep that crossed my mind too. I will work on that. Thank you!