Internal and external details

[Guest]

I am trying to set up a form for trainer details on my training database.
Some trainers are existing employees (internal) and some are external ie
nothing to do with our company. Can I set up a form which deals with both. I
have a trainers table and an employeedetails table. I would like some details
eg contact phone number etc to be displayed and this information is stored in
employeedetailstbl for internal trainers. This can be pulled through on the
input of the employeeID. However, how do I deal with external trainers. All
their information will need to be input manually in to the trainer form. Can
the same controls be used for the 2 input methods or do I have to make
separate controls for internal and external details. If the latter, then how
do I store the details in the trainertable?

Hope this makes sense.

 

[Guest]

Lynn,

Are the record layouts for the interanal and external trainers the same?

 

[Guest]

I have one table for trainers, both internal and external.

 

[Guest]

Lynn,

I have not tried this, but it is worth testing an idea. Do not set the
control source properties for your form to the fields in the employee
details. In the open event of your form your should know whether you are
working with an internal or external trainer. If it is an internal set the
control sources programmatically

forms!MyForm.MyControl.controlsource = whatever your table and field name is

No promises, just an idea.

 

[Guest]

Oh, if you are dealing with an external, you may want to make the fields that
apply only to internals invisible and disabled.