Alert User

[Pam]

I have a form that is used to enter employee
information. Name, address, age, hire date, etc. What's
happening is: When a new employee starts, someone may
enter the employee data into the main form and not add
the employee name to the Employee Name table. Therefore,
the record will be "unmatched" - How can I change it so
in the event that someone doesn't enter the employee name
into the employee table - when they attempt to enter
their name into the main form, they are alerted to
contact the administrator to enter the new employees name.
I hope I am giving the proper information and enough
information.

Thank you

 

[Pam]

I just found what to do - Change the "Limit to List"
property to yes. Where do I have the prompt?

 

[Guest]

Hi Pam,

Why do you have an Employee Name table, and a separate table to hold the
employee information (including the name)? This information should not have
to be entered into two different tables. You do not have a properly
normalized design if this is the case.

Hope that helps,
Bonnie

 

[Pam]

Sorry, I meant to say, where do I save the prompt?

-----Original Message-----
I just found what to do - Change the "Limit to List"
property to yes. Where do I have the prompt?

.