Clear out data (3 Viewers)

[Pat Hartman]

Ok, so you are now believing some scientists but not all. Exactly what I would expect

 

[DHookom]

This is why I don't want to split yet. I can't make these decisions until the database is finished and I have defined everything. There's no problem with forms and reports.

Your database will never be finished (I had to control my urge to type that in BOLD, ALL CAPS)!

 

[DakotaRidge]

You are right Pete. There's very little value in a graphic like this. I rarely look at these things. Years ago, I used Visio. But I really didn't use it to the max either.

There's too much to these technologies for me to understand. So I do what I can to build useful applications, knowing that I am just scratching the surface. I thank folks on AWF and those who were on UA for comments. My favorite way to learn is to study screenshots of forms and reports. I try to attend all the Access User Groups meetings that I can. I attended local meetings for about 15 years.

Your database will never be finished (I had to control my urge to type that in BOLD, ALL CAPS)!

Yes, Duane. One of the things that I learned circa 1998 was that databases are never finished. The same goes for any technology. Look at Word, Excel, and all the others.

What I should have written is "When I distribute my database." My database will never be finished. You nailed it.

 

[MajP]

You are right Pete. There's very little value in a graphic like this. I rarely look at these things. Years ago, I used Visio. But I really didn't use it to the max either.

You kind of missed the point. The relationship diagram is invaluable if you use it to enforce referential integrity. It has very limited value if not. Then you have default joins but no way to enforce data integrity.

 

[DakotaRidge]

You kind of missed the point. The relationship diagram is invaluable if you use it to enforce referential integrity. It has very limited value if not. Then you have default joins but no way to enforce data integrity.

Okay, Pete, you got me. I have a lot to learn.

 

[DHookom]

Yes, Duane. One of the things that I learned circa 1998 was that databases are never finished. The same goes for any technology. Look at Word, Excel, and all the others.

What I should have written is "When I distribute my database." My database will never be finished. You nailed it.

But you said you can’t make decisions about splitting until the database is finished. Apparently you will never split and quite possibly never deliver a working application that will be worth all the effort you are putting into it.

 

[DakotaRidge]

But you said you can’t make decisions about splitting until the database is finished. Apparently you will never split and quite possibly never deliver a working application that will be worth all the effort you are putting into it.

Duane,

What can I say, I misstate things from time to time.

I just sent my family an email showing them how they will be able to track their grocery purchases. I want them to be able to track purchases at all stores, and then view only purchases made at Walmart and other stores in their area. Today, I added three checkboxes to the table to help folks track the ways they try to save money. I suppose developers will say that I should not have added more fields to the source table and then changed several queries.