Hi
I have decided to follow the advice given re a soundex search and create a field in my baptism table named SDXsurname.
so I need to take the value from a field named surname in the baptism table ( format short text) and pass it through Allen Brownes Soindex module and then write the result into the table field SDXSurname which again is in teh baptism table.
So my first step was to create a query based on my baptism table which contains the field Surname and the field SDX surname.
I named it qry_sdx_baptismSurname
Under the criteria for the SDXSurname field I'm trying to populate I added
Code:
SELECT tbl_Baptism.SurnameSDX, tbl_Baptism.Surname
FROM tbl_Baptism
WHERE (((tbl_Baptism.SurnameSDX)=Soundex([tbl_Baptism].[Surname])));
I then opened my baptism table and under the field
SurnameSDX selected lookup wizard and selected the query
qry_sdx_baptismSurname
I get the error
No Valid Fields can be foumd in qry_sdx_baptismSurname. You may have selected a query that uses the table you are adding the lookup column to,
Clearly I am making a fundemental error
any help as usual appreciated