I am not sure if the best way to make this work is to make a separate database for each project with tables for each edition set?
That is an approach that is extremely unlikely to be workable in a FileMaker Pro database. You need a table of projects with one record for each project that you then link to table with one record for each edition set (all editions over all projects). Each edition set record would then link to a table with one record for each photograph.
When you say link what do you mean? establish a relationship on the graph or some kind of portal or button?
Each edition set record would then link to a table with one record for each photograph.
Each photograph in the Edition Set? or a table with all individual photos? Thanks for your help
As someone who is still fairly new, I think the first approach is to get a little more educated. The fact that you are getting tripped up by simple terminology & structure will cause you major headaches as you build this database. Including, but not limited to:
Completely rebuilding, probably more then once-hopefully in the beginning. But some people get very far 'down the rabbit hole' and will easily lose weeks/months/years on a necessary rebuild when they realize they didn't set everything properly.
Loss of data--never good
Severe frustration-spending hours or days on something that as you gain experience/knowledge, you could do in minutes.
Coming to the forums will get you excellent help from the extremely talented and knowledgeable Phil, (who has helped me probably dozens of times, directly, and thousands of times by reading all his posts), and others. But you have to start with more then, how do I build a 'fill in the type here' database?
Here's what I did, even though the temptation to just start building is pretty over whelming. I succumbed, and learned a valuable lesson. The first rebuild was for structure, the second rebuild was for 'now I know what I want'. I'm contemplating another rebuild based on upgrading to 14 and 'now I really know what I (think I) want'.
So for education:
FileMaker: The Missing Manual (for your version). This was the best resource to kick start my knowledge. Work thru the lessons and your knowledge and understanding jumps leaps and bounds.
The FileMaker Training Series for your version (now they have basic-free and advanced-worth it). Do the samples, and the questions.
And the greatest help to me to learn and understand advanced concepts was the VTC training series-about 40-50 hours of video tutorials. Not that I fully understand, but it does spark ideas.
There are also many videos on youTube.
There are many FileMaker blogs with some of the best in the biz doing some great and unique things.
And last and certainly not least, PhilModJunk's Adventure's in FileMaking Series here, which he wonderfully allows you to download for free is just a wealth of intermediate and advanced techniques that make FileMaker life so much easier. (You actually get mad when you struggle over something for hours/days, and you discover Phil simply has a straightforward elegant way to solve your problem) Now his knowledge and experience is something someone starting here new will never equal.
The starter solutions also offer insight to design, scripts, calculations, relationships, etc., so you can pick those apart.
All in all, you'll have a much better experience as you learn and develop (dare I say fun?), and when you get stuck, pop on in for some help.
Still learning everyday...