find values based on text criteria

[boboivan]

Hello!

Is it possible to be automatically added in a query table (or a simple table) a value associated with a text criteria?
The list of text criteria and its associated values are in a different table.
I've made my research and I could find the dlookup function. I've tried it and returns error.

The formula I've tried is:

DLookUp("column3/table2 - Values I'm looking for associated with the text criteria","table2 - of criteria and its values","column2/table2 - the list of text criteria=" & [column1/table1 - where the text criteria are added])

In other words, If I add a text value (an word) in column, I'd like to have its associated numerical value in another column.

From all that I could see on internet, this function works only based on ID column, which is not what I need.

Thx!

[June7]

This is what queries are for - to join related tables so that associated info can be viewed. So why not build query that joins these tables? Why use DLookup?

Any field can be used as criteria, not just an ID field. But if you are not saving an ID from table 2, why even have an ID field?

For example:

DLookup("table2numberfieldname", "table2name", "table2textfieldname='" & table1textfieldname & "'")

Use your actual table and field names in place of the generic examples.

[boboivan]

Thank you June7 for your answer!

Indeed, there is no need for ID in table2, so I'm going to delete that field. This table2 serves as reference for many other tables and queries I want to develop. In table2 is a list of specific word that are associated with specific values. Every time the user adds any specific word in any other table, it is necessary to automatically extract that associated value from table2.

I really don't know if joining tables every time I need an association would be an easy task for me . I'll try though to do that.

Thank you again.