Re: Relationships. Does anyone use them?

rkc wrote:

salad wrote:

I'm curious about your opinion on setting relationships.

When I designed my first app in Access I'd go to Tools/Relationships and set the relationships. Over time I'd go into the window and see relationship spaghetti....tables/queries all overthe place with lots of relationship lines between here and there.

After that first app I didn't do relationships.


So you don't use the database engine to enforce referential
integrity because the gui tool provided by Access annoys you?

Now I am curious. Do you create unique indexes in tables that have
an autonumber as the primary key?

Almost 99.999%

How about using validation rules?

No. The presentation of the error's too ugly.

Field sizes?

If text.

Allow zero length strings?

Fewer than a blue moon.

Required?

Fewer than a blue moon.

.

Relevant Pages

  • Re: Relationships. Does anyone use them?
    ... salad wrote: ... When I designed my first app in Access I'd go to Tools/Relationships and set the relationships. ... Over time I'd go into the window and see relationship spaghetti....tables/queries all overthe place with lots of relationship lines between here and there. ...
    (comp.databases.ms-access)
  • Re: Use Running App
    ... procedure and just call Application.Runif it is the first app or ... > p/invokes Win32 api ShowWindowAsync to post a show-window event to the ... > message queue of the previous process' main window. ...
    (microsoft.public.dotnet.framework.windowsforms)