Table Design

[AndyPandy]

Hi can anyone Help with the following.

All I have to explain is the following.

One branch has one region

Each Branch has two departments Fire & Intruder

Each Department has there own set of engineers IE Intruder and Fire Engineers

Each Branch has there own service Manager

And each branch has the own uniquie id number 201f for fire 201 for intruder.

Then

You have got the following fields for the main data entry of the form

Engid=name
JDE-Number
Comments
CoveringEngId = name
CovengJDENum
Coveringcomments
Mobile Number


What is the best way to go about this.

Would it be one engineers table or two.

Cause idealy the form I would need to create would need to do the following.


Select the branch it would then offer you two choices fire or intruder, you then click on say intruder and it loads up the intruder list for that branch in order or you to edit it etc.

 

[jdraw]

What have you tried? What result? What exactly is the purpose of your post?

 

[MarlaC]

Andy, one table for engineers with a field to distinguish between types, another to assign department, and another for branch. You may want to just make it an employees table and put the managers in there as well.