Help how to do a querry to select another field

[smjacb]

OK be patient with me I am WAY over my head

I have 2 tables - I have a form that populates one table and uses the Primary Key number (auto populated) of the other table. I need a query that takes the value in table 1 and returns the text that corresponds to in table 2 - a simple substitution



so table one

pk id, type (this is the pk of table 2)

table two

pk id (which is type of table one), name of type

I need a query that looks at the type of table one locates it in table two and gives me the name

clear as mud ?

smjacb

[June7]

So you are saving the PK ID of table 2 into field of table 1? You just want to display the associated descriptive text on form?

Options in order of preference:

1. a multi-column combobox, properties:
RowSource: SELECT [pk id], type FROM table2 ORDER BY type;
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0";1.0"

2. form RecordSource is a query or sql statement that joins the tables with join type: "Include all records from table1 and only those from table2 that match"
Bind textbox to the type field from table2 and set it Locked Yes, TabStop No

3. DLookup function expression in textbox ControlSource

[smjacb]

Ok #1 I am familar with because I used combo boxes for my form to enter information.

What I am doing is very much like a recipe ...

I have a form that I enter the ingredients and quantity in
that populates my recipe table - and it puts the pk of my ingre table

What I want to do now is have a query table that has name, ingre, cost

so I need to have the name of the ingr that is indicated in my query. So if it says "1" then looking it up and give me the name of what "1" is. I really want to understand what I'm doing because of course the next hurdle would be calc field take this much of "1" and multi it by that corresponding cost which is the next column over.. isnt there a way to cross reference easy... I am an excel gal but having trouble getting accurate info in excel because I have lots of help that dont enable content and put info in the wrong place. Really need them just to enter info on the form ...

Thanks!

[June7]

That is option 2. Join tables in query. This will make associated info of both tables available for the calcs you describe.

Use query for form or report RecordSource.