[AccessD] Move children from one parent to another

I've seen this done, but have not done it.
Could you use a treeview and move the nodes and therefore the machines to
different factories.

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, September 24, 2010 10:15 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Move children from one parent to another

I have been asked to add a feature to an existing app and am trying to think
of a cool way to do it. The general idea is this:

There are Factories.(PK FactoryID)
The Factories contain Machines (PK MachineID, FK FactoryID)

On occasion, the client wants to move one or more machines to another
factory. Obviously the back-end stuff is simple: for each machine selected,
change the old FK to the new FK.

My initial thought was a dialog that lists the machines in the currently
selected factory, allowing multiple-select; plus a list or combo that lists
the other factories owned by the client. Grab the PK of the new Factory and
walk through the selected Machines, changing the FK to match.

Anybody got a slicker idea?

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com