Jump to content
  • 0

Update The Authentication Table





i have a problem related to an authentication table and i need your assistance.


this table is getting a new record for each order created via a submission form, how ever for existing customers i am encountering a conflict because their credentials already exist  and the table does not accept duplicate entries(unique fields )

i tried to create an report datapage that will check if a users credentials are already in the table and that works but i also need to update content for new users 

so i need to generate a automatic submission form on "no records found"  from the search and report data page.

the process should be automatic. 

on order submission check records on authentication table, if exist do nothing if new submit new info.




I also tried to use a filtered view for authentication but i don't know how to create a view filtered by unique records and attached a password field,  maybe that would be an easier cleaner approach but i dont know how to do it, 


thank you,

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...