If you're REALLY good at filemaker pro, and know how to work with relational tables, I have a pretty challenging little job for you.
I need to create a series of layouts that can be used for script development. The reason I want this in fmp is because much of the data will be imported into an online db, and I need to quickly generate different reports and views of the scripts.
There are several parts to this job but I am posting the main part here. All of the job details will be presented AFTER this part is done because I don't know if it's even possible to do what I need using fmp.
Please see that attached (pdf) example of a script. I need to be able to generate this. It's in Portuguese, but it's pretty easy to see what the elements would be.
The basic schema:
Lessons have scenes.
Scenes have lines.
Looking at the attached example script, the Lesson number is at the top. Then comes the scene details (interior-exterior, the location, day or night). Next is the narrative...