Conditional List

[lewisandrea]

Hello!

I'm creating a new database and I'm having problems with a conditional list.

The table has 3 fields (Code, Prefix, Locality), and when we enter a number in the code field, it automatically shows the available results in the prefix field. I wanted to do the same thing for the location field, but I can't get it to display all the data without me asking to show it.

Example:

(Code, Prefix, Location)

98989, 001, SPAIN

98989, 002, PORTUGAL

30303, 001, PARIS

30303, 005, POLAND

The results that appear in the locale field is for example if I type 98989 in the code and 001 in the prefix it will show me Spain and Portugal and I just wanted it to show Spain. I'm using Filemaker Pro 19, and I work on Windows 10.

 

I really appreciate your help Best regards,

[comment]

If you want to have a value list filtered by both Code and Prefix, then you need to also have a relationship that matches on both Code and Prefix.

 

[lewisandrea]

Helo! Thank you for writing me.

I have relationships like that Sorry about the image being in Portuguese.

 

codigopostal - (Code)

ext_codigopostal - (Prefixe)

localidade (Location)

Tables:

Beneficiários - (Clients)

Código Postal - (Zipcode)

Best regards,

[comment]

26 minutes ago, lewisandrea said:

I have relationships like that

I don't think so. You show a relationship matching on codigopostal. You need a relationship matching on codigopostal AND ext_codigopostal. And if you want to have two conditional value lists, you will need two relationships, using two occurrences of codigo_postal table.

 

[lewisandrea]

How do I do that?

I've tried it several times and the result is always the same

Could you help me?

[comment]

See if the attached demo helps.

 

CondVLx3.fmp12

[lewisandrea]

Thank you!

I'll see how once and then do the same in mine and see what went wrong.