Hello,

I have a form where I have 2 fields,

Per Du & Anrede

Per Du has 2 values: Ja & Nein

Anrede has 4 values: Herr, Frau, Herr Dr., Frau Dr.

When the value in "Per Du" is Ja & the value in Anrede selected the result should be as shown

Per Du    Anrede    Result

Ja            Herr        geehrter Herr

Ja            Herr Dr.  geehrter Herr Dr.

Nein         Herr       Lieber

Nein        Herr Dr.   Lieber

I made two tables in SQL

1. Lookup

2. Du

In lookup I have made two columns: 

Anrede & Salutation

Anrede contains: Herr, Herr Dr.

Salutation contains: geehrter Herr, geehrter Herr Dr.,  Lieber

In Du I have two columns:

Per Du & Anrede

Per Du contains: Ja , Nein

Anrede contains: Herr, Herr Dr.

Now my requirement is When in forms Per Du is Ja & Anrede is Herr the hidden field should automatically fill the value: Lieber

I am not able to get this in Lookup...

Can anyone Please help or tell me what am i doing wrong?

Regards,

Sahil