I want to, among other things, have fields on my main form collect Vendor information (name, address, phone, etc.) and save this data to a table, but NOT if there is already an entry for that particular vendor. I.E. If Machine & Welding Supply is already in the Vendor table, don't add a new row to the table; instead, go ahead and populate the rest of the fields on the form for me. And if ClearView Pools is not already an entry, add a new row to the Vendor table when the last textbox on the form dealing with the Vendor table loses focus.

How can I do that?

Thanks!

Shane

Normally that is a training issue with the users. Typically I will make a look up combo box to find vendors on a form, for example. I put instructions on the form that:

1. Please look up the vendor here first:

2. If the vendor is not in the list, create a new vendor (however you are doing that.)

If the user has to look for the vendor first, then they won't have to spend time filling in all the information that is already there. AND if they have new information, using your scheme, the old bad information would not be replaced, potentially.

I would make them look for the vendor first, and if not in list, create new record.

Did that help?


mmcdonal

That does seem to be a good working solution to the issue.

Hadn't looked at it from that angle, but I will.

Thanks!

Shane