[AccessD] Move children from one parent to another

Doug Steele dbdoug at gmail.com
Fri Sep 24 11:07:41 CDT 2010


I've done something like the query wizard's Field selection boxes: two list
boxes next to each other. If you double click on an item in the left box, it
jumps to the right box and vice versa.  You could fancy it up using 'arrow'
buttons with >, >> and <, << .

Doug

On Fri, Sep 24, 2010 at 8:14 AM, Arthur Fuller <fuller.artful at gmail.com>wrote:

> 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
>



More information about the AccessD mailing list