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

Susan Harkins ssharkins at gmail.com
Sun Jan 4 18:42:15 CST 2015


I hadn't thought of it, but you're probably right. I think I already have
the index in place to tell the truth. :) Thanks for mentioning it!

Susan H.

On Sun, Jan 4, 2015 at 6:49 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Susan,
>
> You could probably use one in your in Salato database if it were larger.
> Keep disposal details
> in a second table for example.  :)
>
> On 4 Jan 2015 at 11:10, Susan Harkins wrote:
>
> > I don't have the serious development experience that most of you have,
> > so my 2 cents is really just 2 cents, but in my experience, 1 to 1
> > relationships are the result of business rules and not something the
> > data itself requires. I've only had to deal with one once. Charlotte,
> > I think we wrote about them, didn't we? I tried to find something
> > online, but couldn't. Perhaps it was in Inside Access -- just don't
> > remember.
> >
>


More information about the AccessD mailing list