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
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).
