Greetings. I am relatively new to Filemaker and haven’t used it in over a year so am a bit rusty. I am working on a quick database for a survey of a couple archaeology site and need some help getting some value lists to filter.

We are surveying multiple sites and each site is divided up into many many quadrants.

When I find a new artifact, I want to be able to pick a Site from a Popup Menu. Then, I’d like to be able to pick a Quadrant from a second Popup Menu. The Quadrants are not unique names between site (both Site A and Site B have quadrants B3) so I want the value list in the Quadrant Popup to only show the quadrants in the selected Site.

The problem I keep running into (I think) is that I am not storing the SiteID in the Artifact table. As a result, my SiteID Popup doesn’t have anything in it. Any suggestions or help? Thanks!

Screen Shot 2017-06-08 at 9.59.09 AM.png

Drew

Powered by WPeMatico