Data Problem

[Guest]

Hi

I run Win2k with Access 2K.

I have a table that lists a number of different descriptions (ie Zinc,
Steel, Aluminium etc etc).

I have a form that has a combo box that looks at this table displays the
list for selection on the form.

When I go to the table that holds the data, instead of Zinc or Steel etc
being displayed, it displays a number 1, if I add another record it displays
the number 2.

The field is formatted as text and the entry is left aligned in the column
which I assume verifies this.

Has anyone any idea why it is showing a number instead of the text that is
in the form field?

Thanks

 

[Douglas J. Steele]

Sounds as though you're using a Lookup field. See
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for why we
recommend never using them (this is only one of the many drawbacks)

 

[Guest]

Thanks for your promt response Douglas.

Could you please suggest the best alternative to what I am trying to achieve?

Thanks

John

 

[Douglas J Steele]

Presumably you've got a main table and a second table that holds the
descriptions. Create a query that joins the two tables, and make sure that
the query shows the description from the second table in addition to
whatever else it includes.

Use that query as the basis for your form, not the table.