RE: Partially Resolved - Forms - Adding Multiple Rows to 2nd Table

[Bill Downall]

On Tue, 15 May 2001 18:47:33 -0500, Dennis McGrath wrote:

>But what puzzles me is why you would have two tables that must have 
a
>one-to-one relationship.
>Sounds like a poor design.

Not necessarily bad design, Dennis.  Optionality (zero-or-one to one 
relationships) can be considered here.  For example, a Mortgage 
application done in a single table might have 200 fields, 100 of which 
were irrelevant if the applicant didn't pass the first qualification review.  
Why waste all that unused space in your design?