linking one table to another

[lillyehrhart]

i have my main form and i have a field called description. i created a separate table that is going to house where i would pull the description from. I am looking to link the description column in my other table to the field called description on my main form. please help i am stuck

[Rabbit]

I'm not sure what your question is. You have said what you want to do but not what trouble you're having doing it.

Also, it's a bad idea to link by description as that sounds like a free form text field. And that's always a bad candidate to use as a key field.

[lillyehrhart]

i have a table called main, then i have a second table called codes. the code table contains code, descr and class. the main table form also has a place for the code, desc and class. i want to house all of the code and descr data on the code table. then based on the code from the main table, it will show the desc as well that is going to be pulled from the code table. i am not even sure where to start on it. my prim key on my code table is the code field, not the desc

[Rabbit]

That sounds like a better set up than what you had in the first post.

When you want to pull the description, in a query, you join the two tables on the code field.

[lillyehrhart]

i have already joined the two tables when you go to query design, but that does not make the anything show up on the forms

[Rabbit]

You have to make the query the record source for the form. And bring in the new field as a control on the form.