Value field Error Message

[Guest]

I created a form and in one filed which is a company name, I look it up from
another table then I get the ID in this field not the name of the company, so
I cut and past to the field in my form, but it gives me an error that I've
entered a value that isn't valid for this field. In the table I've identified
it as Text not Number.
can you any body please let me know what I did wrong and how to fix it.
Also, is there is a way to look up information from a table and put the
information in another form automatically.
Thanks

 

[Guest]

If you want to be able to tie your data together based on common values, the
preferred method is to assign a numeric id to each entity in the source table
and then store just the id in whatever other tables need that info.

To allow for easy maintenance, use a combo box where the data source is your
stored value and the row source is a simple query that extracts the id number
and a text identifier with it. Assuming that the number is in col 1 of your
query, setting its width to zero will hide that value and only show the text
that most users will understand. A side benefit of doing this is that the
existing value from your table will also be displayed as text not a number,
but will be stored as the number.

The combo box wizard should help you to set it up correctly.