lewisandrea

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

How do I do that? I've tried it several times and the result is always the same Could you help me?

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,

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,

I understand, but we have other automatic systems that do not accept letters, that is, only numeric and when we say 75 to the system it does not know in which table to look for information.

Yes just for that, and to be easier with the records

Yes, basically that's it! We have to use a letter to differentiate the staff from the scouts, but it was proposed to use only one serial for the entire database. In other words, a scout with ID 75 will stay with him forever without the need to change.

For example Staff Member 1 - 35 Scout - 36 Staff Member 2 - 37 Staff Member 3 - 38 Scout - 39 it is currently impossible to make a unique sequence with the ID because I have 2 for the staff and the scouts

I will ponder with my team. but is there a solution to my question?

I am developing a database for my scout headquarters and it has the following structure that is shown in the attached image. But we are facing a problem because we would like the ID of both the scout and the team to be unique and sequential. Will it be possible? I appreciate your help;)

Hello! How to create a personalized login system, one that introduces the name and password?

Hi Such a thing only in filemaker https://theonegenerator.com/generators/documents/ssn-generator/ When creating a new record he gives the SSN automatically and randomly. Thanks for the help

Basicamente, é criar um gerador SSN no criador de arquivos, mas atendendo aos critérios definidos pelo SSA Whenever we create a new record it automatically enters the number generated in the field.

Hi! I'm new to the forum and I don't know if this is the right place, if I'm not sorry. I am developing a database for a project in my school subject and I can't finish could they help me? The teacher asked us to create a formula so that following the SSN criteria and randomly and automatically the filemaker gave this number. The example he gave was as follows: When creating a new record student A automatically received the following SSN: ###-##-1234 which according to the same criteria is valid, repeating the same step student B automatically received the following SSN: ##-##-1235 which according to the criteria is the same.