Basic Database Design
"Silvex" u36021@uwe wrote in message news:758166b4acb83@uwe...
Hi people.
I am attempting to develop a new database and I’m new on Access.
It will work (I hope!) like this:
Database has 4 Tables:
tblCategory (CategoryID;CategoryName;Description).
tblProducts (ProductID;ProductName;CategoryID; InsuranceID;UnitPrice)
Silvex,
I see that each product may only have one category. This may be what you intended, but in
most businesses products can have more than one category, so I just wanted to point this
out.
If it turns out that your products may have multiple categories, you will need a new
table, tblProductCategories (or, preferrably, ProductCategories), that has:
ProductCategoryID -- PK
ProductID --\
CategoryID -- 2-column unique index.
tblInsurance (InsuranceID;CompanyName;Phone;Fax) and
tblClient (Date;ClientName;Category;Product;Insurance;UnitPr ice)
I have a list of Twelve Insurance Companies
Each Insurance Company furnishes all the products, but with different prices
from one
Insurance Company to another.
I want to create a Form where I insert this data:
1)The Form will look like this: Frm Client based on TblClient
Date: ___(Field Date)_______
Name: ___(Field ClientName)_____________________
Age :__(fldAge) ___
And perhaps other fields to identify the client ….
Category: __cboCategory____(Rowsource from tblCategory)
Product: __cboProduct___ (filtered from the cboCategory)
Insurance Company: ____cboInsurance____(Rowsource from tblInsurance)
UnitPrice: __txtBox __(which should automatically fills with the Price for
that product that the Insurance company that I selected previously is paying)
- AND where is where i'm stucked
Forms questions belong in:
microsoft.public.access.forms
microsoft.public.access.formscoding
Example1:
snip example 1
Example2:
snip example 2
Example3:
snip example 3
I most sincerely hope that none of that is private medical information that belongs to
real people, but it sort of looks real, which makes me wonder . . .
Sincerely,
Chris O.
|