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,

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.

 

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,

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.

 

How do I do that?

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

Could you help me?

See if the attached demo helps.

 

CondVLx3.fmp12

Thank you!

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