Breaking down information.

  • Thread starter Thread starter Scott Viney
  • Start date Start date
S

Scott Viney

G´day All,

Iam looking for some general ideas about breaking down some information
about Products. At the moment I have a table with all the Product details,
brand, price, tax, number of units etc etc.

But for each brand there could be hundreds of products. Is there a better
way of doing this. Maybe a table for each brand of products perhaps.

The other thing is to try and make it easier for a person to enter data for
products, I tried messing around with a form with a combo box for the brand
and a subform to list all the product data. But I couldnt make the subform
update with the products of the brand selected. Is this difficult to do??

Cheers,

Scott V
 
TblBrand
BrandID
BrandName

TblProduct
ProductID
BrandID
<<ProductDetails>>

Use a form/subform where the main form is based on TblBrand and the subform
is based on TblProducts. When you select a brand in the main form, you will
automatically get a list of the products in that brand.
 
Cheers mate,

That sounds like the easiest approach. I will give it a crack.

Have a good one,

Scott V
 
I have created all of this through the wizards and it works exactly right.
But it would better to select the product brand from a combo box than
scanning through all the product brands with the record selectors..

So I created an unbound combo box that lists all the product names. But how
do you make it update the subform that lists all the product details for
that brand name?? Do I have to do this with VBA?

Thanks again for your help.
Scott
 
Still use a form/subform. Put the unbound combobox in the main form - you
don't need any other controls. Set the bound column property of the combobox
to 1, Column Count to 2 and Column Widths to 0;1.5. Set the LinkMaster
property to the name of the combobox and the name of the LinkChild property
to BrandID.
 
Back
Top