Searching Memo based on DB Records!

[jepoysaipan]

Hi Guys,

Nice to be back again, as always I am in need of help

I have 2 tables namely: JobVacancies & JobCandidates both of which has common memo field type, AvailablePosition for JobVacancy & PreviousPosition for JobCandidates. Now I want to create a query to search the available candidates on JobCandidates DB based on the available position which is available from JobVacancies.

I've been trying for the past week, but still facing a blank wall so I decided to ask the best guys here.

Thanks in Advance!

 

[Galaxiom]

Since the fields are memo then I presume they have a large amount (potentially > 255 characters) of manually entered unstructured text.

Trying to find a match from one unstructured text field in another unstructured text field is really messy and requires incredibly intensive processing. I would describe this as an intractable problem in your current database structure. It could be done but it would be ridiculously slow and unreliable.

These fields should have been normalized which would have allowed matching with a simple fast query.