Aviation Photo Database
I've finally settled on FM to create a database for my large collection of aircraft photos (yes, very nerdy, I know :P). I am using FM for Mac, and would most definitely consider myself a beginner with FM. I have set up all the fields and the relationships I need, and the autofill lookup is working perfectly.
Basically the database consists of 3 tables: Aircraft, Airports and Photo Database. References are set up so that I enter an aircraft registration and the remaining aircraft information fills in automatically (similarly for the airports).
I am now wanting to add some more advanced features to the database as follows (I have included a screenshot from layout mode):
- In the airports table, I am hoping to add another field that consists of a custom list dependent on the airport itself. Basically I want to select an airport, then select a particular location from a list of locations that are specific to that airport only. How would I go about doing this?
- I would like to set it so that when I click a button located below the original photo (which will be a RAW photo file with .CR2 extension) it opens the file in Adobe Photoshop CS5. Similarly, I would like the edited photo to open in the default photo browser. Is there an easy way to do this?
- The JetPhotos_ID (bottom right) is only useful when the Editing_Process (bottom left) is set to a particular value. Am I able to hide the JetPhotos_ID option at all times, except when the Editing_Process is set to a particular value (in this case "Accepted")?
I am sure I will have many more questions as I progress with this project. Many thanks for any help that can be offered, it is sincerely appreciated.