Simple Validation

  • Thread starter Thread starter Aleman
  • Start date Start date
A

Aleman

hi, i have 4 tables: employees, projects, machinery and supervisors
what i want to do is a screen for the supervisors that are incharge o
assigning the machinery the screen goes like this first you input th
employees netid or name and then everything must populate in theor
thats my problem i want to make a key field and make the other
populate based on this field i've tryed many ways but no luck what
get is #name? and i looked for the dll that help sais but no luck als
its there can anybody help

thnx
Alema
 
I think I would set a form up with unbound textbox’s on it and one combo box.
Then I would build a function to select all information from each table you need.
When you select an item from the combo box call your function and pass it the employee ID. After it has found the information you need pass the record set back to the form to populate the unbound text box’s.

Keith
 
hi, i have 4 tables: employees, projects, machinery and supervisors,
what i want to do is a screen for the supervisors that are incharge of
assigning the machinery the screen goes like this first you input the
employees netid or name and then everything must populate in theory
thats my problem i want to make a key field and make the others
populate based on this field i've tryed many ways but no luck what i
get is #name? and i looked for the dll that help sais but no luck also
its there can anybody help
Click to expand...

RElationships won't automagically make data appear on the screen.

Could you describe your tables, and how they are related; the form
("screen") that you're using; and what you're doing to make the data
"populate"?

Note that none of this has anything to do with validation, the subject
of your post...
 
Back
Top