What's new in Customer Journeys?

Connect and learn more! ×
VB Forms and giving an error when a combo of 2 fields already exist in the data — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

VB Forms and giving an error when a combo of 2 fields already exist in the data

Accepted answer
26
Views
3
Comments

Summary:


Content (please ensure you mask any confidential information):

Hi all,

I have a form in VB with BO that have parent/child relationships. I have a table called 'Input' that holds the data when user clicks submit. In this table, I want an error message to pop up if a combination of tag number (text field from input table) and supplier name(this belongs to a table named 'Supplier' and it is the parent of the table 'Input') already exists in the 'Input' table.

I thought making both fields unique in the 'Input' table would solve this issue, but it treats them separately instead of as a combination.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!