C
Céline Brien
Hi,
One form for user without permit.
One form for user with permit.
If a user without permit takes a permit, a click on a button transfer the
user in the form for user with permit and destroy the user without permit.
But !
Sometimes a user with permit is created, and we realize to late that the
same user already existed in the form for user without permit.
I would like, after finishing to type the user address, using the form for
user with permit, to verify if the address already exist in the table for
user without permit.
In both form, the address is compose of three fields : number, apartment,
street. The merge of the three fields should form a unique key.
I already create a query QryAddressWithoutPermit creating the field
AddressWithoutPermit merging of the three fields.
Could an event after update of street field in the form for user with permit
compare the new address (merge of the three fields) with the
AddressWithoutPermit of the QryAddressWithoutPermit ?
Hope this is not to confusing.
Thank you for your help,
Céline
One form for user without permit.
One form for user with permit.
If a user without permit takes a permit, a click on a button transfer the
user in the form for user with permit and destroy the user without permit.
But !
Sometimes a user with permit is created, and we realize to late that the
same user already existed in the form for user without permit.
I would like, after finishing to type the user address, using the form for
user with permit, to verify if the address already exist in the table for
user without permit.
In both form, the address is compose of three fields : number, apartment,
street. The merge of the three fields should form a unique key.
I already create a query QryAddressWithoutPermit creating the field
AddressWithoutPermit merging of the three fields.
Could an event after update of street field in the form for user with permit
compare the new address (merge of the three fields) with the
AddressWithoutPermit of the QryAddressWithoutPermit ?
Hope this is not to confusing.
Thank you for your help,
Céline