[AccessD] Home inventory problem

Hi Steve:

Have you tried looking into the use of a flexgrid? If you have access to VB6
or the like, the flexgrid can be used by referencing the FlexGrid control
'msflxgrd.ocx', the Hierarchical FlexGrid control 'mshflxgd.ocx' or/with the
ADO Shape control 'msadodc.ocx' (available through ADO 2.0 and up). 

I have only had to reference the Hierarchical FlexGrid once for a client
when the requirement was for viewing data in various groupings depending on
which column, from the list presented that was selected. The grid would
re-form with each click. The control names might be slightly dated (dlls
might be used now) as the application was created at least five years ago
and it has not required changing in these areas.

See Microsoft reference to the flex controls at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/htm
l/vbconhflexgridcontrol.asp (watch for wrap)

Or a sample ADO shape command being used:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=6512&lng
WId=4

Without going into great detail...

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
Sent: Sunday, April 03, 2005 5:26 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Home inventory problem

Dear Group,

A friend who's pretty sharp on computers (PHP development and a fair
amount of VB.NET) asked me to help him figure out a way to handle his
home inventory. He has LPs, Books, video cassettes, etc., half a dozen
different categories in all of things he wants to record in tables. So
far he's made an individual collection table for each type of item:
Books, LPs, Videos, etc.

His question was how to make a master table that had common
information in it -- purchase date, purchase price, location in house,
and category. He was also trying to figure out a way to have a big
master form, perhaps with a tab object, and subforms for all the
tables containing his collections.

I admit that I was a bit stumped. It's easy enough to determine that
the master table should have, say, an AutoNumber key field for each
item in his entire home inventory and that the individual item tables
would link to the master through a foreign key or simply with a Long
Integer field containing the Master key. But there would be a
one-to-one link between the master and the collection tables.

But what he'd like to do is see multiple rows for each of his
collection items at the same time. This implies that the subforms
would NOT be linked to the master. If they WERE linked to the master,
then only ONE item from ONE collection table would show up.

Have you lot ever tried something like this? His notion is that if the
Master table contains the location for each item then he can easily
query the master to find all the items in, say, the upstairs closet.
But then creating a report or a query might be a struggle since he
could conceivably have items from six different collections in that
closet...or only four of the collections.

I think you get the drift. Each collection has enough unique
information that keeping the items in separate tables makes sense, but
pulling all the information together to make an inventory valuation
might be a chore. Any ideas?

Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
www.swerbach.com
Security Page: www.swerbach.com/security
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com