I’d like to add paleo context to my locality form. Can I add it as a querycbx or a subview?
You can add Paleo Context as either a query combo box or a subview depending on the configuration in your database.
To find the configuration in your database, you need to run a SQL query. Since your database is on the Specify Cloud, I can do this for you!
I need to run this query to find the current configuration:
select Name, IsPaleoContextEmbedded, PaleoContextChildTable from discipline WHERE Name = 'Paleontology';
The results of that query shows me this:
This tells me the following:
- Paleo Context is currently “scoped” to the Collection Object, not Locality.
- Paleo Context is currently “embedded”, which means each Collection Object must have a unique Paleo Context (they cannot be shared between objects)
I can update your database to change both of these settings. We can change the Paleo Context level to be ‘Locality’ and we can make it so that you can share a single Paleo Context record between multiple Locality records.
You can learn more about the differences between “Embedded” and “Shared” Paleo Contexts in this doc:
Just let me know what configuration you’d like (embedded or shared)!
Once I make the changes in the database, you can add it to the appropriate form using the appropriate view!
I think having it tied to the locality form and shared between objects makes more sense for our collection. If that could be changed that would be great, thanks!
I’ve configured your discipline (Paleontology) to have Paleo Context linked to your Locality records and they can now be shared between multiple localities!
Let me know if you have any questions!