Hi everyone,
I’d like to verify answers entered in a form through external tables (in Excel, for instance).

Here is the situation
I run a competition and need to create two forms for the registration of
– teams
– members of each team (already registered)

The field linking both tables is the “team’s name”

For the “Team’s Members” form, I want to make sure the Team has already been created => I therefore need to test the “Team’s name” entry :
– if the entry exists in the “Teams” database (Excel file linked to the Form, I guess) => the user will be allowed to enter the data for a new member
– if it doesn’t exists, then the user will NOT be allowed to carry on (with a message indicating he has to create first a “Team”

Any idea on how to do this ?
Thank you in advance

​Hi everyone,I’d like to verify answers entered in a form through external tables (in Excel, for instance).Here is the situationI run a competition and need to create two forms for the registration of- teams- members of each team (already registered)The field linking both tables is the “team’s name”For the “Team’s Members” form, I want to make sure the Team has already been created => I therefore need to test the “Team’s name” entry :- if the entry exists in the “Teams” database (Excel file linked to the Form, I guess) => the user will be allowed to enter the data for a new member- if it doesn’t exists, then the user will NOT be allowed to carry on (with a message indicating he has to create first a “Team”Any idea on how to do this ?Thank you in advance  Read More

​