Duplicate Fields in Table design

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

Is it possible to have duplicate fields in a table? Here
is what I need. Below is the field names.

Control Box--# units--Terminal Facility--# units--Monitor--
# units, etc.

thanks,

Troy
 
Is it possible to have duplicate fields in a table? Here
is what I need. Below is the field names.

Control Box--# units--Terminal Facility--# units--Monitor--
# units, etc.

thanks,

Troy
Click to expand...

Certainly not; fieldnames must be unique. And this would be EXTREMELY
non-normalized design.

If you have a one to many relationship, store it in *multiple
records*, not *multiple fields*. Storing data like "Control Box" in a
fieldname is a guaranteed recipe for trouble!

You should have whatever this table is related one-to-many to a second
table with three fields: a foreign key linked to the primary key field
of your main table; an ObjectType field with values "Control Box",
"Terminal Facility", "Monitor" or whatever; and a Units field (don't
use # in fieldnames, Access gets confused).
 
Back
Top