Its a typical scenario, user selects their name from a list and I want to auto-populate their e-mail address and phone number so they can check it on the screen before the Add happens.
I can make the drop-down list from the Contact table but how do I then make a query that populates the additional info AND checks that an e-mail address and phone number exists.
If I can do it before the Add I can give the user a chance to add their correct details before commiting the record.
Its as if I want an Event called "After Field Update" that triggers on a selection from the drop-down.