Getting myself confused and need some help please!

[emeraldstar]

Hi All,

I'm new to MS Access and am having a bit of a tough time so I thought I'd turn to you experts for some advice / guidance.



I have successfully imported a text file with a price list of products into a table. The price list includes separate fields for brand, model and price. Each record has a unique primary key number generated by Access. What I'm looking to achieve for now is a way of inputting a customer order in to a form. I want access to provide me with a drop-down list of the brand and once this brand has been selected for the form to restrict the models of equipment to only the brand selected. This saves me having to scroll through a very long price list! I then want to be able to select this item, type in a quantity and then move on to the next item, adding it to the customer order.

Can anyone assist me please?
Thanks
Marty

[Minty]

You are after a thing called cascading combo's.

Have a look here http://baldyweb.com/CascadingCombo.htm
Paul's site has a simple demo you can download to see the methods employed.

[mike60smart]

Hi Marty

To manage Brands and Models you would need the following table structure:-

tblBrand
- BrandID - Autonumber - Primary Key
- Brand - Text

tblBrandModels
-BrandModelID - Autonumber - Primary Key
- BrandID - Foreign Key - Number (Linked to BrandID in tblBrands)

You would then use Cascading Combobox's in your Form to allow you to select a Brand using the 1st Combobox
and then the 2nd Combobox would only display those Models associated with the Brand selected.

[CJ_London]

from your description it sounds like you want to use cascading combos in a continuous form which gets a bit more complicated

See this link for a way to do it https://www.access-programmers.co.uk...s-form.275155/