G
Guest
I have inherited a database with a main table that holds about 100 fields. I
know what you're thinking - "glorified spreadsheet" - and you're absolutely
right. I have never had to normalise something this big before, so I was
looking for some opinions.
For example, I have three fields in the main table:
[Title]
[Subtitle]
[TitleShort]
I figure this should be made into another table, [Titles], with three
fields, [ID], [TitleType] and [Title], and link it to the main table. Does
this sound correct?
Furthermore, if all these fields are required for each record, how would you
display these on a form? Subform? I don't want users to have to enter the
[TitleType] every time. Form based on a cross-tab query?
I'd love to hear your thoughts.
know what you're thinking - "glorified spreadsheet" - and you're absolutely
right. I have never had to normalise something this big before, so I was
looking for some opinions.
For example, I have three fields in the main table:
[Title]
[Subtitle]
[TitleShort]
I figure this should be made into another table, [Titles], with three
fields, [ID], [TitleType] and [Title], and link it to the main table. Does
this sound correct?
Furthermore, if all these fields are required for each record, how would you
display these on a form? Subform? I don't want users to have to enter the
[TitleType] every time. Form based on a cross-tab query?
I'd love to hear your thoughts.