input form using what querie?

  • Thread starter Thread starter lynn atkinson
  • Start date Start date
L

lynn atkinson

I have a table holding details of trainers. Some of these
trainers are internal staff, in which case I want some of
the details from employeedetails table to be displayed.
Other trainers are external and are therefore not in the
employee details table.
I want to be able to input external trainers without the
database trying to create a record for them in the
employeesdetails table. But I also want the link to the
employeedetails table for internal staff.
All this information is to be used to create an input
form.
How do I get my head around this?
 
If you have a uniqueId as the primary key on the Employee
Details table then you should include this on the Trainers
Table as a column set to Not Required. That way, if it is
null for a particular trainer, he/she must be external.

If the person's name is the primary key on the Employee
Details Table, then you will need a Yes/No column on the
Trainers Table to say whether or not he/she is external.

Hope That Helps
Gerald Stanley MCSD
 
Back
Top