Base: Creating a new database for existing data

James3359 · Posted: Wed Oct 21, 2009 3:01 pm Post subject:

I wonder if I can ask for a bit more help. I'm now trying to create a set up where I can view the part of the contents of the Books Catalogue and the Saward Classification tables together, and which will update when I add new items to the Books Catalogue table. I have tried queries, but AFAICT they are stuck at the point when you run them and they don't update when new data is added. I have tried table views, but they also seem to have the same problem

Any ideas?

Lorinda · Posted: Wed Oct 21, 2009 3:19 pm Post subject:

Queries should update when you add or change data. Why don't you send me your odb file as it stands now.

It may be a while before I can get to it. One of my children has been home sick with both strep and influenza, and my own temperature is climbing tonight, so I may not be good for anything for a few days. Sad

Send it anyway, as there may be a point in my recovery when I need something quiet to keep me occupied.

Lorinda

James3359 · Posted: Thu Oct 22, 2009 2:36 am Post subject:

Very sorry you're not well - and it's even more worrying with children too. I hope it passes soon.

In the meantime in the clear light of day, I've taken another look and discovered the source of my problem. I had already discovered yesterday that I might need to set update and delete cascades in the relationships between the main Books Catalogue table and the Saward Classification table, so I've done that (I'm still not 100% sure it was necessary). But the main problem was a data error on one record which meant that that record was being excluded from all my Views, Queries etc., and of course that was the record I was checking to see if things were working properly. If I had checked the other recently added records I would have found they were all right, and got to the problem on this one more quickly.

I have now produced a table view which combines Books Catalogue fields with Saward Classification fields, and sorts by Genre, Class# author's names, and title. I have then created a query based on that view which finds only the Theology 'Genre' books which are not pamphlets. This now gives me a shelf listing for my work related library.

I am very happy to send it through to you if you want to see it (although you've obviously got plenty on your plate at the moment), but at the moment I don't think I am in need of help (or at least not with NeoOffice anyway!).

Lorinda · Posted: Thu Oct 22, 2009 5:30 am Post subject:

I'm glad you got it working.

Thanks for the good wishes. Fortunately this morning I'm only feeling moderately ill. I still have vivid memories of the last time I got influenza, 20 years ago while studying in France--one of the rare years when I did not get a flu shot. I was one sick puppy! Last night I was steeling myself for a repeat of that experience, but in the light of morning it looks hopeful that it will not be that bad this time around.

My child is much improved, which is indeed a relief.

Lorinda