Databse Tables

[Andyjones]

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 engineersIE Intruder and Fire Engineers

Each Branch has there own service Manager

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

Then

You have got the following fields for the maindata 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 createwould need to do the following.


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

[June7]

One table for engineers with a field for the type (Intruder, Fire).

Sounds like you will want dependent (cascading comboboxes). Review: http://datapigtechnologies.com/flash...combobox2.html