table structure/relationship question 1

[fredk]

Hi - I am setting up a new database and I have a question about structure.

I am trying to use minimal duplication so that my structure is as normal as possible.

I have a table that holds the specific quoting records - this table is called tblQuotingInformation and holds a field called carrier. Carrier is an outside company that we use to provide the product. I have a seperate table called tblCarrier that holds the Carrier Name and the Carrier Number (carrier number being the primary key)

My question is, when I create a data entry form for the tblQuotingInformation table, how should I handle the carrier information that I list in the tblQuotingInformation table? I believe I should use the carrier number (according to normalization) That being said, for the user, they need to enter the name

I believe I should use the carrier number in the tblQuotingInformation table. In the data entry form, how do I make the transition from the user entering a "name" and the form storing the corresponding number?

Hope that makes sense!!!

thanks very much!!!!

Fred

 

[KenReay]

Hi

You are worrying unnecessarily, this is simply achieved by using a combo box, with two columns, the number and the name, set the bounf column to be the number, and the width of this column to be zero, the user will see the name but the form will save the number into the table. The combo box wizard will guide you through all this

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[fredk]

I see what you are saying - my prolem is that only the number value is in the tblQuotingInformation table - I believe I can just set up a query based on the carrier table with the two fields and use your advice from there - I did this and the only problem I am having is after I select the name in my combo box, the combo box value vanishes and there is no value in the combo box.

Any idea on what I am not doing?

Thanks for your help!!!

Fred

 

[fredk]

I figured it out - I did not update the column count property to "2" - This is working fine using a query as the rowsource.

Thanks for pointing me in the right direction!!!

Fred