I have 4 tables:
- Clients (list of clients)
- Websites (list of websites with a record link to a client many to one)
- Pages (list of pages with a record link to website many to one)
- Changes (list of changes to web pages with a record link to pages many to one)
If I view a Change record detail, I can see the page it’s associated with and the website that page is associated with. But is there a way of also getting the Client to display as well. Client isn’t a field on either Changes or Pages, but it’s certainly part of the relationship.
I guess there would need to be a way of adding Client to either the Changes or Pages table - but I’d want to do it automatically based upon the selection of a different record. For example, on the Pages table the Client is automatically selected based upon the website selected.
Is any of this possible?