Soundex() linking

[Kundan]

Can we link the main form and subform on the basis of the SOUNDEX() FUNCTION ?

[CJ_London]

not sure what you mean, soundex is a way of comparing words that sound the same (e.g. 'might' and 'mite'), Can you explain what you are trying to acheive

[moke123]

If your talking about Master\Child links I suppose you could as long as each recordsource contains the soundex value.
Note however that soundex (at least the one I use) is not all that accurate by itself. For instance "Might" and "Mite" actually return different values.
I do a name search where I actually test for an exact match, a levenschtein distance match, and a soundex match which together return a fairly accurate result.

As Ajax notes, it would really be helpful to know what it is you wish to achieve.

[Kundan]

not sure what you mean, soundex is a way of comparing words that sound the same (e.g. 'might' and 'mite'), Can you explain what you are trying to acheive

In case there is a spelling mistake in typing in the field that links the main form and subform, then I should also be able to view the misspelled entry.

[CJ_London]

still doesn't make sense - just choose the form from the drop down menu

[orange]

kundan,
You're focused on soundex as a linking field between form and subform. Can you step back and tell us about your application in simple terms?You have not provided sufficient information to get a meaningful answer, in my view.

[CJ_London]

OK - think I understand - you have a main form with a record which has a field which is the calculated soundex value. And you have a subform with a fieldwith a soundex value and you want to populate the subform based on these values.

If so, the answer is yes - basically soundex produces a string value - but because these are not in a relationship, the properties will not populate automatically, you will need to do that yourself - in the subform control properties (not the subform itself) enter the name of the field on the main form in the link master property and the name of the field in the subform in the link child property. Note the fields need to be generated in the query uses in each recordsource, not as a calculated control

[Micron]

In case there is a spelling mistake in typing in the field that links the main form and subform, then I should also be able to view the misspelled entry.

Here's another take on that - "if I type in the field that links the main form to the subform but I misspell a word in that field, I want to ctach it"
Probably wrong though.

[Kundan]

Here's another take on that - "if I type in the field that links the main form to the subform but I misspell a word in that field, I want to ctach it"
Probably wrong though.

For example, the name "Sahu" can also be typed as "Sahoo". Now, when I type "Sahu" in the linked field of the main form then I want the subform to show all "Sahu" and all "Sahoo" too. How to achieve this?

[Micron]

Gotcha. From what little I know of the concept, you'd have to run the function on both the child and parent linked fields and test for a numerical match.

[CJ_London]

further to my answer in post #7. The other way to do it would be to repopulate the subform recordsource on the mainform current event


me.subformname.form.recordsource="SELECT * FROM someTable WHERE soundex(namefield)='" & soundex(me.namefieldParent) & "'"

[moke123]

heres an example of a name search which uses an exact match, a levenschtein distance and a soundex match.

searchdb.zip

The search loops through the names and constructs an array of the PK's for any matches or near matches. If matches are found you are presented with a list to choose from or you can choose to continue and add a new person. If no matches are found you go straight to entering a new person.

[Kundan]

heres an example of a name search which uses an exact match, a levenschtein distance and a soundex match.

searchdb.zip

The search loops through the names and constructs an array of the PK's for any matches or near matches. If matches are found you are presented with a list to choose from or you can choose to continue and add a new person. If no matches are found you go straight to entering a new person.

Thanks a lot!!!!!!!!!!!!! GOD BLESS YOU!!!!!!!!!!!!!!!!!!!!!!!

[Kundan]

Gotcha. From what little I know of the concept, you'd have to run the function on both the child and parent linked fields and test for a numerical match.

Thanks a lot!!!!!!!!!!!!! GOD BLESS YOU!!!!!!!!!!!!!!!!!!!!!!!