David McAfee
davidmcafee at gmail.com
Fri Sep 24 12:50:02 CDT 2010
The way I handle my machines is by insertions: tblCompany CompanyID CompanyName etc... tblAddress (a company can have multiple address) AddrID CompanyID etc... tblMachineMaster MachineID SN ModelID etc... tblMachineInstalls MachineID AddrID InstallDate installNotes entryUserID entryDateTime I simply make a new insertion into my Machine Install table I have an "move machine" screen where a SN is entered and the customer information pops up on the left. The new customer is selecter (or entered, if new) on the right and the machine is now "moved over", with self auditing historical records showing that it was located at old customer prior to install date. On Fri, Sep 24, 2010 at 9:07 AM, Doug Steele <dbdoug at gmail.com> wrote: > 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 >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >