[AccessD] Confused by One to Many versus One to One

Yes, I've used that approach many times in exactly that kind of situation,
Stuart.

Charlotte

On Sun, Jan 4, 2015 at 4:01 AM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> On reason for 1-1 is where you have a large number of fields common to all
> records and a lot
> more that only apply to one type of record.
>
> One possible example would be a vehicle fleet with a mixture of leased and
> owned vehicles.
> Instead of fields for all the lease details in every vehicle record, you
> put the lease details in a
> second table with a 1-1 relationship.
>
>