Relationships. Does anyone use them?

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. If I had a query, I defined the relationship. Many of the times when I create a new query and add 2 tables together it creates the correct relationship between the two tables. I believe this is due to using a foreign key with the same name. I cared not about cascading deletes or cascading updates or the type of relationship so the relationships window is clean of tables.

And if I need to, I'll create a query on the fly via code. Again, I set the relationships. I know these queries aren't compiled for optimacy like a querydef but operate well.

My apps don't appear to suffer from no relationships. Speeds very acceptable, the results the same. So is setting relationships just more overhead in creating an app and unnecessary...or do you believe the app should have all relationships defined?




.

Relevant Pages

  • Re: What to do when disaster strikes but requires user input
    ... Have the 2nd app continually attempt to lock the record. ... the first app may have shut down. ... The issue that I have is that sometimes the failure is a type that requires ... if more than 40 minutes have passed since the last datetime value update, ...
    (microsoft.public.fox.programmer.exchange)
  • RE: App display different on PCs other than development PC
    ... I have just installed my first app on another machine and found exactly the ... When I install it anywhere else, though, the font appears smaller, ...
    (microsoft.public.dotnet.general)
  • Re: What to do when disaster strikes but requires user input
    ... the second app checks this file, if it does not exist or the entry ... I wrote another App which makes sure that the first App ... the second App restarts the first App and sends ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Re-entrancy???
    ... Create an application that has two loops, one that calls DoEvents in it the other not. ... If you run the first app without the DoEvents, the second app will take longer to complete on a single processor machine, then if you run the first app with DoEvents. ...
    (microsoft.public.vb.general.discussion)
  • Re: Relationships. Does anyone use them?
    ... After that first app I didn't do relationships. ... If I had a query, ... the type of relationship so the relationships window is clean of tables. ...
    (comp.databases.ms-access)