Parish Puzzler!

First - hire Interactive Tools to build you a batch uploader that creates a unique record per magazine which includes:

• Magazine Title
• Magazine Publish Day, Month and Year
• Magazine Topics or Summary if needed
• And any other necessary fields you need per magazine issue upload.

This will save you enough time that it would pay for Interactive Tool's labor to build many times over.

Next build a search engine that queries ONLY the magazine records, with a field search to query keywords of the magazine titles, topics and/or summary, also build a set of drop selectors for search by month and/or year. This would allow the user to drill down on magazine issues using keywords or by month or year.

Here's a link to a thread where I was asking a similar questions to accomplish a similar task, which has a solution. You'll need to modify it a bit to fit your needs, but most of everything you'll need is there. I'd shed more light on this, but I have a phone meeting in 5 minutes, so I wanted to at least share something that I think you can use to get started with.

http://www.interactivetools.com/forum/forum-posts.php?postNum=2207818#post2207818

I do recommend hiring Interactive Tools to build the multi-file batch uploader as well... it will save you a considerable amount of time creating your records.

Hi Perchpole,

I think Zickys suggestion of creating a record for each magazine is definitely the way to go. You could have an upload field for each record that only allows you to upload one item (see attached screenshot), and then have fields for the title, description, publish date, etc. By doing this it will also be very easy to sort/search/filter the records in future. 

It would be possible to create a script to import your current records into this new section, which would save you some time in having to reupload/recreate everything. This is something we would be able to help you with via consulting if you need.

Let me know if you have any questions.

Thanks!

Greg