Thanks John, very helpful.

 

I know I have a road to travel but tell me how you see the destination. Where will I view my table list of pages? Will that be in one of the three tables (if so which?)

 

So far I had created the Folders and Pages tables. I'm just learning how to create the releationship and only show the fields I need. I need to get my head around the left and right arrows and it seems the arrow on the data model goes the wrong way. Its not sending data from one table to the other but asking. An yway I'm sure the confusion will pass!

" Relationships are always created from the Many side. "

 

I think this is the best bit of advice I've had all year! Didn't know that. Thanks.

"it seems to me you want to only view tasks that are not complete. Do you give your tasks priority? Are some tasks more important than others?"

 

No, not really. Let me expand on the puropse of this database.

 

The 'Folders' are photgraph albums, the 'Pages' are pages of photgraphs in the albums. The photographs are to be digitalised. This requires a number of tasks to be completed. Some of these tasks require to be done in order, but generally there is no importance.

 

I wonder id I do really need the seperate 'Tasks' table suggested? I'm not yet clear on the advantage / disadvantage.

 

What I want ( and seem to have created) is an 'Index Page' for my Folders. This is a spreadsheet style table:

 

Folder   Description

A          Year 2000 - Some other info

B          Details about theis folder

 

When I click on a Folder entry I'm taken to a spreadsheet type view which lists all the pages in that Folder with some basic detail

Page     Description              Date             Note

A/1      Photos from Event     Jan 2000      Short note

A/2      Some other event     Feb 2000      Another note

 

Now I click on a Page entry and go to a page with all the details I need relating to that Page. This will include the type of film (B&W or colour), other detail and then the 'Tasks'. The Page need to be Scanned then captioned and a couple of other workflow items.

 

So the Tasks are really part of the Page. If I have a seperate Ninox Table for Tasks I need to bring them to my Page and that makes the design a bit messy (as they appear as a spredsheet style table). If the Tasks were fields in the Page I can just enter the data there and arrange the design as I wish.

 

When I get clever at this I'd like to have an 'at a glance' data on the spreadsheet style Page. Perhaps some colour denoting progress

 

Page     Description              Date             Note            Scanned    Captioned

A/1      Photos from Event     Jan 2000      Short note    [green]     [red]

 

Thanks.

Sorry for all the typos, the entry filed won't resize for me and you can't edit once posted.

Earlier I was thinking I don't need the seperate Table. But as I add data I can see its easy to have a view of all the Tasks and I may want to build a list showing which Pages haven't been scanned - for example.

 

The Tasks are: Scan, Date, Caption, Keyword and Rate.

 

The same Tasks for each Page, not necessarily in order but all need completed. Will there be more? Never say never.

 

Some Tasks are Choice fields. Scan is Yes/No but other fields can be No / Some / Yes.

 

I may not need but I think I will keep Tasks in their own Table.

 

Thanks and soz for any typos!