Frustrated at work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone explain to me the following concept? How do I auto populate a
checkbox in one table based on data from another table? Basically, everyone
that has an entry in Table A needs to have a check in a field in Table B.
Anyone?
 
There are a number of ways to do it, but the answer is you shouldn't! If
you did, you would simply duplicate information, which is in breach of
the basic rules of relational database design. Whenever you need to know
(in a query, form, report etc) just check if a record exists in the
other table - or restrict the recordset for the current operation based
on the existence or not of a matching record in the other table (my
guess is the latter is probably what you are trying to arrive at?).
If you need more help, provide more information please.

Nikos
 
Back
Top