[AccessD] (no subject)

OK, so I've got my little license database all put together, reports, forms
etc. Just one little problem.

On reports a field, ProfLicense, is showing up in white on black. It is from
a subtable, tProfLicense, and is a title pulled from another table,
tCertification. The tCertification table has only 1 field containing the
various types of certification. No ID field. Just want to fill in the field
ProfLicense.

In the report, the properties list tells me that the field is being sucked
in from tCertification, not tProfLicense. I have a one to many relationship
set up between the main table, tEmployees, and a foreign key in the
subtable, tProfLicense, because an employee can have more than one license.
In properties I can't make the field appear in the normal black on white.
How come?

Serves me right for trying to normalize, grumble grumble...

Karen Rosenstiel
Seattle WA USA
karenr7 at oz dot net (Spam blocker -- resolve into a real email address)