combobox from table

[Scooterbug]

What bob is saying is that by storing the data in several places, the database is becoming de-normalized. If you are using the combo box to fill data into one table from another, you will run into issues later on. For example, what happens if Steve Smith moves? In order to reflect that change, you are going to have to go and find all the records where Steve Smith's address is stored and change it.

Now, if you store the ID number for Steve Smith in a table, then you only have to change the address in the table where his address is changed. Because you are only storing the ID number of Steve Smith in the second table (and using that relationship to find his information) when you use that ID to get his information it's current.

You might find it benificial to read up on Normalization. There are pleny of posts here that go indepth into it. You can also google it (Stick to the .edu sites for the best information)

 

[awake2424]

All the information is stored in one table.

1 Steve Smith 212 Acorn Lane
2 Jim Jones 526 Powers Street

My form searchs for the identifier, in this case 1
in the first text box Steve Smith is returned
and in the second text box 212 Acorn Lane is returned

If I set the control source to the table name all the values that follow are the same. How can I set it so that the values are different each time and able to be saved in the form? Thanks.

 

[Scooterbug]

if that is how your table is setup the row source for your combo box should be:

SELECT ID, FullName, StreetAddress From TableName;

Also, is this combo box on a continuous form?