One to One

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

Guest

I have a problem entering details in a one to one relationship. I am using a
one to one to manage the large amount of information for each record...each
exhibitor can enter one or more sections and for each section there is
different information required.

My set up:

Exhibitortbl
ExhibitorID
 
Helen

Using a 1:1 table relationship because you have a "large amount of
information for each record" is very likely a symptom of a serious condition
that sometimes infects MS Access databases. I am referring, of course, to
the painful itch of "spreadsheet-itis".

It is unusual to find well-normalized Access (or other relational) databases
with more than 30 columns (fields) in a table. Perhaps, rarely, as many as
60.

How many are you facing? Given that you are using 1:1 relationships to
connect multiple tables, I am guessing you have more than 255...

The answer to your question is (probably) to more-fully normalize your table
structure. Otherwise, you won't be able to easily use the tools and
functionality that Access offers.
 
I have a problem entering details in a one to one relationship. I am using a
one to one to manage the large amount of information for each record...each
exhibitor can enter one or more sections and for each section there is
different information required.

My set up:

Exhibitortbl
ExhibitorID
Click to expand...

I'll presume there was more to post here...

One to one relationships are VERY RARE. Are you in fact using
Subclassing here, in which each section requires not only different
contents of information, but different *kinds* of information? If not,
I suspect you actually have a many (exhibitors) to many (sections)
relationship.

More details please!

John W. Vinson[MVP]
 
Back
Top