Very good.
The first thing you will to do is add the suppliers record set to you insert page. In the record set window add a filter. Select the Supplier Number column and use "=" and then select Form Variable and type the name of the Supplier Number input field you have in the insert page.
Second, Select the error message that you want to display, and in the Server Behaviors Panel (Window -> Server Behaviors) click the + button and choose Show Region and select Show if Record Set is not empty.
Last, you will need to add the same condition to the DataAssist Insert Server Behavior. Basically copy the top line of the show if server behavior which look something like this:
<?php if ($totalRows_WAContents > 0) { // Show if recordset not empty ?>
and place it at the top of the DataAssist insert Server behavior. So you should have something like this:
<?php if ($totalRows_WAContents == 0) { // Show if recordset empty ?>
<?php
// WA Application Builder Insert
if (isset($_POST["Insert_x"])) // Trigger
{
and you will also need to need to add this line to the bottom of the DataAssist Insert Server Behavior:
<?php } // Show if recordset not empty ?>
If you have any question about these steps, please send me your insert page in a zip and i should be able to assist you. Please remember that the code i have above is an example and the names will be different.
