Keep number of fields low

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

Guest

Setting up a database on some equipment to reference numbers from different
illustrations to multiple parts of the equipment and I am wondering how to
tie this together so I don't have to use so many fields. Each piece of
equipment will have three sections, each section can have up to 18
illustrations
 
How about the following tables:
TblEquipment
EquipmentID
EquipmentName
<<Other fields that are in a 1:1 relationship with the equipment item>>

TblEquipmentSection
EquipmentSectionID
EquipmentID
SectionDescription
<<Other fields that are in a 1:1 relationship with the equipment section>>

TblSectionIllustration
SectionIllustrationID
EquipmentSectionID
SectionIllustrationDescription
<<Other fields that are in a 1:1 relationship with the section
illustration>>

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Steve said:
How about the following tables:
TblEquipment
EquipmentID
EquipmentName
<<Other fields that are in a 1:1 relationship with the equipment item>>

TblEquipmentSection
EquipmentSectionID
EquipmentID
SectionDescription
<<Other fields that are in a 1:1 relationship with the equipment section>>

TblSectionIllustration
SectionIllustrationID
EquipmentSectionID
SectionIllustrationDescription
<<Other fields that are in a 1:1 relationship with the section
illustration>>

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
Click to expand...


--
You are *not* a resource at all !!
Stop advertising here, or get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html

ArnoR
 
Setting up a database on some equipment to reference numbers from different
illustrations to multiple parts of the equipment and I am wondering how to
tie this together so I don't have to use so many fields. Each piece of
equipment will have three sections, each section can have up to 18
illustrations
Click to expand...

Any time you find yourself saying "each <x> will have up to some number of
<y>" then you should immediately STOP thinking about fields and start thinking
about adding another Table. You need a table of equipment related one-to-many
to a table of Sections, which is in turn related one to many to a table of
Illustrations.

John W. Vinson [MVP]
 
Isn't that what I suggested, John?

Steve

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top