DlookUp Vs Relationships

[ErikRP]

I have 2 tables set up as follows:

TableA
Procedure, Edit1, Edit2, Edit3, Edit4
e.g.
Cleaning,00801,00304,00000,00000
Filing,00304,00000,00000,00000


TableB
Edit, Description
e.g.
00801,This procedure is eligible once per quarter
00304,This procedure is not covered under your plan

What I want to do is display the information on a form using Table A and matching each of the "Edit" fields with the appropriate English description. I would think this should be easy but I'm missing the solution. My first thought was using dlookup. For the Edit1, I created an unbound control box and called it Edit1Desc. I keep getting an #error when I use this formula:

=DlookUp("TableB","Description","[Edit]=[Me]![Edit1]")

Then I tried to establish a relationship, but I wasn't sure how to go about doing it, what type of relationship, and what should match to what.

Any help would be appreciated!!

 

[ColinEssex]

DLookup is ("FieldName","TableName","Conditions")

(your field and table are round the wrong way)

Col

 

[ErikRP]

Thanks Colin, that's got it!

That's what I get for trying to figure out a simple Access problem at 7 in the morning!! : )

 

[ColinEssex]

You'd better get another coffee !!!