Relationship & Design Issues

[Pam]

I have an Access DB that tracks errors. One tracks minor
errors (DB1) and the other tracks major errors (DB2).
I created separate tables for each. The only other table
I have is the table for departments. How should I set up
the relationships? Both tables 1 & 2 contain a department
field.

Also, I want to create the forms on separate tabs. DB1 on
one tab and DB2 on another tab. How do I go about setting
that up?

Thank you all your help and your past help as well

 

[John Vinson]

I have an Access DB that tracks errors. One tracks minor
errors (DB1) and the other tracks major errors (DB2).
I created separate tables for each. The only other table
I have is the table for departments. How should I set up
the relationships? Both tables 1 & 2 contain a department
field.

The two tables are not related, since an error recorded in one table
is by definition not going to occur in the other. If you have a
Departments table then both of these would be related one to many to
Departments, but they're not related to each other.

If the information you collect about an error is the same (i.e. the
same fields and datatypes) for the two classes of errors - or even if
there are a few fields that are filled in for major errors that are
not needed for minor - you may want to reconsider and use a single
table, with a checkbox Yes/No field for Major. You can always use a
query selecting False or True on this field to pull out just minor
dust-ups or critical catastrophes.

Also, I want to create the forms on separate tabs. DB1 on
one tab and DB2 on another tab. How do I go about setting
that up?

I'd use an unbound Form, with two Subforms, one bound to DB1 and the
other to DB2.