Jump to content

Conditional List


This topic is 1019 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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,

Link to comment
Share on other sites

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,

A.png

Link to comment
Share on other sites

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.

 

  • Like 1
Link to comment
Share on other sites

This topic is 1019 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.