AnsweredAssumed Answered

One-to-One Relationship

Question asked by disabled_rcmiller9 on Dec 15, 2013
Latest reply on Dec 18, 2013 by philmodjunk

Title

One-to-One Relationship

Post

     Are there any inherent advantages or disadvantages to creating a table which will have a one-to-one relationship with another table?  A search of the Forum didn't seem to any return any results for one-to-one relationships.

     The new table would likely have some 100-150 fields and would need to be consolidated every year and would hold primarily historical data that would not be heavily utilized.

Outcomes