I have two tables. My DETAIL table and my RULES table.
NUM | FAMILIA | EXAME | other fields not importante
x aa x-ray leg 2 parts
y aa x-ray arm
z bb ECO
and my Rules table are:
FAMILIA | SeachString | %for value
aa leg 50
aa arm 40
bb ECO 12
I need to include in my DETAIL table [% for value] to all records.
I tried the function lookup and it's always give me the exactcorrespondencebetween the fields but i need to search in field EXAME [table DETAIL] if exists in ( begin middle or end) the string SearchString[table RULEs ].
I hope my result is:
NUM | FAMILIA | EXAME | other fields not importante ! %for value