Sad Der
accessd666 at yahoo.com
Mon Oct 20 07:28:44 CDT 2003
??Question you've got a many-to-many between you're products table and you're parts table, correct? So you would have: Tablename: Product Fields: ID(=Primary Key), Description Values: ID Description 7 Table 9 Chair Suppose the table and chair both use the same wooden 'leg' Tablename: Parts Fields: ID (=Primary Key), Description Values: ID Description 1006 WoodenLeg If you would create a table that holds the relationships between products and parts, eg tblBOM, with the fields ID_Products and ID_Parts. this would create the following: ID_Products ID_PARTS 7 1006 9 1009 Wich are unique! Or did I miss something? Hope this is what you need. Regards Sander --- "Garraway, Alun" <Alun.Garraway at otto.de> wrote: > Hallo Terry, > > AFAIK all the records showen in a treeview have to > be unique, > (there was an article about creating unique keys for > a treeview > at devx written by Arthur Fuller, sorry don't have > the link, > maybe somebody else does....) > > which would mean that in your case a treeview would > be hard to > get working. > > hth > > alun > > -----Ursprüngliche Nachricht----- > Von: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]Im > Auftrag von MACE, Terry > Gesendet: Sonntag, 19. Oktober 2003 23:50 > An: 'Access Developers discussion and problem > solving' > Betreff: [AccessD] Treeview and Listview Displays > > > Can anyone tell me if either Treeview or Listview > can be used to display > data in a many-to-many relationship. > > I have a Bill Of Materials database where several > parent parts may have the > same child part that I want to display. > > Thanks > > Terry Mace > _______________________________________________ > 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 __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com