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/specif...malization.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.../q209/5/34.asp

Intermediate:

MySQL's website:
http://dev.mysql.com/tech-resources/...alization.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/da...ng/rm/rm7.html

Sincerely,

Chris O.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200707/1