Creating Table field based on field in another table

[llgreen]

Hello!

Sorry, I am very new to Access, and trying to create a database for a charity I volunteer with.

Essentially, I have one table called 'Main Table' with records including a condition selected from another table called 'Conditions List'. 'Conditions List' also has a field called 'Condition Code'.

I'd like to create a new field in the Main Table which contains the 'Condition Code' (from Conditions List) for the condition selected.

I think I could do this using a DLookUp function, but unsure.
Could anyone offer any help?

Thanks very much!!

 

[stopher]

You should not create a field in your main table. Instead, you create a query which allows you to view data from two or more tables joined by the appropriate key(s).

 

[llgreen]

Ahh, perfect! Thank you.
The only reason I need the Condition Codes are for reports.

Is there a way I could create a query to replace the Condition with the Condition Code on the reports?

 

[stopher]

Sure. Either create a query with all the fields you need in your report. Then set the report data source to the query instead of the table.

Or double click on the data source in your report which will probably ask you if you want to create a query. This will open the query designer showing your table. You can add your second table, create the join between the two tables, then add the extra fields you need to the query. When you close the query editor, the extra fields will be available for you to use in your report.