Can Access do this??

[gordyb]

Hi all,

First please let me let you know that im a complete novice in Access.

My question is this, i would like to create a database which has 5 columbs...

Products, Description, Size, List Price, Discount %

Under the Products tab, i would like a user to be able to click a down arrow to select from a list, a product. Also when a user selects a product the decription will automatically show.

In the size column, the user could select from a pre-determined size.

How do i create a drop down tab so a user can select the relevent item, or does this happen when i add more and more products into the database?

P.s. is there any good Access websites out there that you can recommend for a novice.

Thanks.

Gordon
UK

 

[DCrake]

Suggest you look at the Microsoft Solutions Norwind.mdb as a starting point.

also read up on Data normalisation, naming conventions & reserved words.

Welcome to AWP.

David

 

[HiTechCoach]

Gordon,

Check out:

Customer Order Entry Template

 

[Scooterbug]

First step in any good database design is to setup your tables properly. One way to learn this is to read up on Normalization. Having good table structure will make developing a database a lot simplier.

As to your question, yes you can do it. What I would suggest is to have two tables.

tblProducts
ProductID (Primary Key, Autonumber)
ProductDesc

tblYourDesiredTable
RecordID (Primary Key, Autonumber)
ProductID (Foreign Key - Stores the ProductID from tblProducts)
Size
ListPrice
Discount

You can then setup a One to Many relationship between your desired table and the Products table. You can also create a combo box (drop down list) to display the products and allow your user(s) to select one.

 

[gordyb]

Thanks to all who have givin me a starting point.

So is it good practice to keep the tables for the different items seperate, all the products into one table with the description and relevent sizes, or am i ok to put everything into one table?

I take it that once the database is completed, a user could just select the correct items. Then if you wanted to, you could easly create a printable form that shows his/her items they want to order.

Gordon
UK