I have the following database structure that I’d like to use for documentation:
- Systems
- Data Stores
- Fields
- Component Categories
- System Components
- Data Stores
Where the nested databases are on the many side of the one-to-many relationship. I also have a many-to-many relationship between system components and fields. I want to make it easy when documenting a system component (CRM workflow, function, document merge, etc) that I can pre-filter the fields lookup where the field is within the same system. In both Fields and System Components I have a lookup field on their parent entities’ System lookups. But it doesn’t look like relationship links within an entity can use “This” fields. I work on a systems development team in a holding company, so we deal with many systems, and field names will obviously repeat across them, which makes it almost impossible to search.
If this isn’t possible, do y’all suggest a better way of accomplishing this? Right now I configured the field and component name to be a formula of their parent system and category/data store. While this is helpful for searching, it isn’t ideal as our documentation grows.
