Move record

[Jay B]

I have a two table database with a one to many
relationship. I track my customers safety equipment
inventory at service intervals. It is common for this
equipment to get moved from one customer building or
location to another or a vehicle. I would like to be able
to locate the item by serial nbr, click a button, pop up
a window asking for the correct cust nbr to place this
item in, type in the correct cust nbr and have the
inventory item "Moved" to the correct location. Key
field in customer is the customer nbr, key field in the
inventory table is Serial Nbr... Thanks

 

[John Vinson]

I would like to be able
to locate the item by serial nbr, click a button, pop up
a window asking for the correct cust nbr to place this
item in, type in the correct cust nbr and have the
inventory item "Moved" to the correct location.

ummm... do you not have a Loction field in the table? Normally you'ld
simply update that location value. You don't have to move data around
to change the location of an item!

How is your table structured? Where is the Location of the item
stored?

 

[Guest]

I understand your reasoning, but in this case, One
customer may have many different facilities around the
state, each of which is assigned a different customer
number. At times, the customers equipment is moved from
Cust Nbr 100 to Cust Nbr 250 location. Of course Cust
Nbr is linked to serial nbr in the many side of the
database relationship so it is necessary in this instance
to move the entire "Many" side record to a different
customer location.

 

[Jay]

My Customer / Parent table is Keyed on customer number
with the usually customer info following. My child table
is Keyed on serial nbr with the following fields Serial
Nbr, Location, Brand, DOM, Type.
Thanks and sorry to be a bother.