Product Descriptor Tables

LzAnn

Registered User.
Local time
Today, 12:20
Joined
Jun 11, 2010
Messages
19
Greetings all database workers,

I am still working on the table structure of a database to help my dad and brother with plumbing estimates. There are three tables relating to the Products table to store product details, defined as ‘Descriptors’. The descriptors are: Size, Angle, Flowrate, Flue, kW, m3p/h, Watts and Manufacturer (the only non-numeric descriptor).

So I have Descriptors and Products, but as each product can have different descriptors, somehow I need to link the descriptor values together. To do this I thought about consolidating descriptors appropriate to the products, for example, for radiators, we need to know (Size, Watts), so in the corresponding DescriptorDetails could be (400x600mm, 2111w). I realise this is not recommended and will make searching by the fields Size or Watts really difficult.

Does anyone know a better and also simple way to combine/link these descriptors to the appropriate product? I think I could do it using another field, something like ‘ProdDescValue’ in the ProductDescriptors table and in the many to many table linking the descriptors together with this field – this is just an idea, not confident about it at all, so any thoughts on this, or an alternative method, or advice would be much appreciated.

Have attached a PDF Relationship Report of the table structure so far - I hope this all makes sense!

When (if!) I eventually get something up and running, will very gladly post on the forum for anyone out there with a similar project J
Thank you.
 

Attachments

Why not have a descriptor table, and then use the table in a single field in one of the other tables, you would use the datatype of lookup wizard link to the table, then find the table, select the fields etc to be displayed and continue through the wizard, that should do the trick.
 
Thank you very much for your reply Trevor G.

Sounds great, but I'm not sure I understand fully - could you possibly explain in a bit more detail?
 
Create a New Table and give it a name, use the name of the fields you want to show, like product and description, then fill the table up with the products and descriptions.

Next in the table where you want to use the product list and descriptions go into design view and then either create a new field or an old (I suggest to see this work, create a new one).

In the dataType click the drop down arrow, and then select Lookup Wizard, then move onto your other table (Just created) move on and then select both fields to be viewed.

Then continue and descide which column to safe as the entry.

Save close and test it.
 

Users who are viewing this thread

Back
Top Bottom