On the form the make and model fields were synchronized via the make and
model tables. However at first when I went to a second student and enter
data I change the make and model of the first student to wqhat had been
entered in teh first students records. I realized that my make and model
table were only "value lists for lookup purpose and not storing the data. I
change the bound property to my student cars table and all worked. Data
stored and recalled on my forms. However when I ran a report pulling fields
from my student cars table I got numbers in my make field. Not ford, Chevy
etc. I realized acces was storing the linked number between my make and model
table. I used the autonumber from make table and a number field in my model
table as the realtionship. I had to add code to the
row source property of the model number field and then instead of the number
showing the actual name of the make was then showing. I followed access help
file that is how to synchronize combo boxes examples. Thanks
No. You did NOT need to add any code to the report. Storing the numbers is
correct.
What you can do - for a Report - is base the report, not on the table of cars,
but on a Query joining the table of cars to the table of Makes, by the MakeID;
and to the table of Models, by ModelID; you can then include the text name of
the make, from the Makes table, and the text name of the model, from the
Models table.
It sounds like you may have used the Lookup Wizard. Like many before you, this
obnoxious misfeature has deceived and misled you. Your table *appears* to
contain the make and model; it doesn't! It contains (as you saw) a numeric
foreign key. You just needed to take the next step, and base your report on a
query which does contain those names, rather than on a misleading table which
doesn't.
