Move Record

[Jay Brown]

I have a two table database. Customer is Parent table
linked to Inventory on a one to many relationship. Some
of my customers have multiple locations throughout
Florida and occasionally this inventory equipment is
moved from one location to another. Each location is
listed in the Customer table as a separate location with
its own unique number. I need to move a record in the
inventory table to a different location with a different
existing customer number. Currently we are deleting the
record from its current location and manually inserting
it with the proper customer nbr.
Thanks for any help

 

[Sam]

Assuming you have the relationship defined you should be able to select the
required records and just copy (or cut) and paste them from and to a sub
form. Just make sure the secondary key (in your inventory table) is not
displayed on the subform.

HTH
Sam