Difficulty in Table Design.

[drspanda@gmail.com]

Dear All,

New to Access.
I have 6 tables and I am trying to build database. Main target is Module Info Table. My basic Idea is when user inputs data in module information form, which I would create later. A combo box to select device type. Depending on the device type for example:

If device type is BMR then user shall be filling BMR form.
If device type is CT Operated BMR then user shall be filling BMR form as well as CT form.
If device type is EMPR then user shall be filling EMPR form.
If device type is FUSE then user shall be filling FUSE form.
Finally data is to be available from module info table.

As part of basics, data is ultimately stored in a table. I am facing difficulty in table design.
Advance thanks to all of you.

 

[jdraw]

Please tell readers in plain English WHAT you are trying to do. Describe the business this proposed data base is intended to support. No jargon, no access terms -just a plain English overview of WHAT is involved.

 

[drspanda@gmail.com]

Dear,

I am trying to build database for Module Information. Each Module shall be protected by one or more protective devices. protective devices are BMr, EMPR, FUSE. Some protective device may require CT. For this purpose I have made tables of below:

1. Module Info
2. BMR
3. CT
4. EMPR
5. FUSE
6. PROTECTIVE DEVICE

My attempt:
PROTECTIVE DEVICE table has PROTECTIVE DEVICE ID and PROTECTIVE DEVICE TYPE fields. In the PROTECTIVE DEVICE TYPE field I have BMR, EMPR, FUSE as records.

Module Info table has Module Info ID PK, CT FK, PROTECTIVE DEVICE ID FK. I am not satisfied with the table design because of CT FK field. some records may have it or not. I am looking for a better design which can cater my requirement.