Document management conundrumn

Hey there - what's the code you're using to select which documents to show on each page?

Hi Claire:  see attached file

Thanks. It's not clear which table the documents are attached to, however. Can you explain which section has the documents?

Hi Claire:  it's both tables. Minutes_overview for the public files and minutes_rods for the private. 

Ah I see. Okay, it might be a problem if the documents are stored in two different sections, and there are multiple documents stored in each record.

Are all the documents for each record all set to the same status?

Claire:  Right now, it works, but if the client wants to publish a document to both public and private, he posts them twice.  I was hoping to merge the 2 tables into one and have a checkbox (public, private, both) which would then allow publication in the appropriate area.  Not sure how I would do this. I have attached both schema definitions.

The actual merge could be tricky, but it looks like the fields are the same. Assuming you could get all the records into one table, adding two checkboxes - one for public, one for private - would work fine. All you'd have to do is make a few changes to the logic in the two getRecords calls.

ok, but how do I add the checkboxes to each file entry?  Would I use info2 & info3??

Ah I'm sorry - this isn't going to be possible with checkboxes. You'd have to move the documents into a related records section, or just add 'public' and 'private' to their info fields as needed.