Using form to update location change of inventory

[jtp607]

I have an inventory of equipment that is assigned to different locations. When repair is needed, the equipment is brought in and swapped with a loaner. How can I update on a form the location change from "A" to "Shop" that will show up on the related equipment table? I have "Location" in the table, but don't know if I need something to the effect of "NewLocation" to assist in showing the equipment swap. I appreciate any help with this, thanks.

 

[jdraw]

Please post a jpg of your tables and relationships.
Should be available from your Database tools window.

 

[Tiger955]

I have an inventory of equipment that is assigned to different locations. When repair is needed, the equipment is brought in and swapped with a loaner. How can I update on a form the location change from "A" to "Shop" that will show up on the related equipment table? I have "Location" in the table, but don't know if I need something to the effect of "NewLocation" to assist in showing the equipment swap. I appreciate any help with this, thanks.

What about understanding that "Location" is the CURRENT location?

In case you need to know what the original location is, you need another field in the table.

 

[jtp607]

Here is the jpeg that you asked for. The equipment is the LifePacks, Stretchers and Toughbooks. The equipment locations are the Rescues or Engines. I am using a form that control source is the Repairs table. I hope this makes sense, thanks again for any help.

 

[jdraw]

I looked at your model. A few points -- you should use only alphanumerics (no special characters eg #) in your field and object names. This could cause you syntax issues later.

I am recommending this link to help with table design and relationships.


I would suggest abstracting your specific Equipment (in separate tables) to tblEquip and tblEquipType. I'm wondering how your database design will change if you get another type of Equipment.