Jump to content

Status problem.


This topic is 6491 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello, I have a database that is used for keeping track of the status of images and the pages of a catologue.

There is about 10 images a page and I need to show the overall status of one page of the catalogue. For instance has it been planned scanned of is it finished.

The problem im having is that if I have a record for each image on a page there will be about 10 diffrent records for one page, What I need to do is have a field on the main db page called Page Status that tells me if the page has been planned scanned or finished. But that would mean changing all 10 fields instead of just changing one and it changes the status of the page for all 10 records.

Is there a way of making the page status show the same status for each image record?

I hope that made sense, thanks for any help.

Chris.

Link to comment
Share on other sites

"I hope that made sense,"

Not quite but here goes.

If you are changing the Page status and you want this reflected in the Image records, then :-

Define a relationship from the Images to the Page, and in the Image file define a field Status. Define Status to look up PageStatus in the Page file - make it an unstored calculation. Then each Image record has the status of the whole Page.

I hope that made sense,

Link to comment
Share on other sites

This topic is 6491 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.