Dlookup oracle tables

[IELV]

Hi everybody,



I have one problem when I try to use the function dlookup in a form with two Oracle tables vinculated:

The expression I use is

=DBúsq("OPL_DESCRIZIONE";"ES74_WLI_OPERATORILINEA" ;"[RP_CAPOTURNO]=[OPL_CODICE]")

The two tables vinculated are:

1) ES74_WLI_OPERATORILINEA with the fields: OPL_DESCRIZIONE and OPL_CODICE

2) ES74_VW_REPORT_REPORT_PRODUZIONE with the field RP_CAPOTURNO . This table is the origin of the form.

The field show "Error".

What is very extrange is when I pass the mouse in the table vinculated the name of the table is diferent: ES74.WLI_OPERATORILINEA and ES74.VW_REPORT_REPORT_PRODUZIONE

I imagine the problem is the use of Oracle tables, because with SQL Tables the function work.

Could somebody help me?

Thanks in advance.

Best regards,

[Gicu]

Your dLookup doesn't look right, can you try:

=DBúsq("OPL_DESCRIZIONE";"ES74_WLI_OPERATORILINEA" ;"[OPL_CODICE] =" & me.[RP_CAPOTURNO]) if CODICE and RP_CAPOTURNO are numbers and you have a control on the form named RP_CAPOTURNO or
=DBúsq("OPL_DESCRIZIONE";"ES74_WLI_OPERATORILINEA" ;"[OPL_CODICE] =""" & me.[RP_CAPOTURNO] & """") if the two fields are text (using double double-quotes avoids problems with apostrophes in strings).

Cheers,
Vlad