Re: Basic Database Design

Shi! Chris.
Now you really scare me.
I thought it was a little and basic thing to do.
I have no time to study all that books but I will visit those sites you post
me.
I was already thinking if the struture and the alterations that you send me
previously, where enought
to solve my problem whitch is, 3 comboBoxes in the form (cboCategory,
cboProduct,cboInsurance)
On cboCategory I select the Category .One category have several products, so
on the CboProducts I will select the proctuct from the Category I select
previously ( I think I know how to do the code for filter cboProducts to the
Category selected on cboCategory). Now, the Client has a Insurance Company
(always the same, doesn't change). There are various Insurance companies and
all fournish all the products at diferent prices. What I wish is that when I
select the Insurance company (on the third comboBox - cboInsurance) that the
client I'm recording is associate, the price that this company pays for the
product I select on the cboProduct, will automatically appears on the
UnitPrice Txtfield.
regards
Silvex

Chris2 wrote:
Chris Thanks again.
I will try to do the design that you have send, and will "post" you a note in
order to tell you if it worked. OK
Regards
Silvex

Silvex,

The table designs I provided were suggestions.

You need to be able to review them for applicability to your situation, and modify or
extend them as necessary.

To do that, you'll need some further knowledge on the subject of database design.

Books: General: Beginner

Database Design for Mere Mortals by Michael J. Hernandez

SQL Queries for Mere Mortals by Michael J. Hernandez, John L. Viescas

Database Normalization:

Basics:

About.com
http://databases.about.com/od/specificproducts/a/normalization.htm

Tips to Get You Going
http://home.att.net/~california.db/tips.html#aTip1

Microsoft: Description of database normalization basics in Access 2000 (not significantly
changed by Access 2007, see the article's own references at the end to material from the
early 1990s).
http://support.microsoft.com/support/kb/articles/q209/5/34.asp

Intermediate:

MySQL's website:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

Advanced:

Wikipedia:
http://en.wikipedia.org/wiki/Database_normalization

Very Advanced:

University of Texas:
I like this whole site, since it has a handy menu on the right describing many important
aspects of the database world:
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html

Sincerely,

Chris O.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200707/1

.

Relevant Pages

  • Re: RSFC advice column
    ... I've thought about the database stuff too. ... SQL would actually make ... Wrox has some pretty good books on learning basic computer stuff -- ... Mere Morlals) SQL is easy to do with a good database design. ...
    (rec.sport.football.college)
  • Re: books about database design / modeling
    ... Two of my favorite books about databases are: Database Design for Mere ... Mortals and Sql Queries for Mere Mortals. ...
    (comp.databases)
  • Re: Knowledgeable yet simple book for database modelling or database design
    ... database modellingi.e. from which we could ... design....Coz I think database design is the crucial part of database ... State what version of SQL Server you are using and specify the content ... SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)
  • books about database design / modeling
    ... Any recommendations for database design / data modeling / application ... Most 'database' books seem to focus a lot on administration and not much on ... Any good books I should look for? ...
    (comp.databases)
  • Re: Basic Database Design
    ... the Patient appears and I open my Database on the ... Each Insurance Company furnishes all the products, ... note that you can dispense with the CoServID primary key field, ...
    (microsoft.public.access.tablesdbdesign)