Hi Everyone, I’m Emmanuel Katto from Dubai, United Arab Emirates (UAE) I’m facing a situation I haven’t encountered before, and I’d like to get your thoughts on it.
Here’s the scenario:
I have an object, a “hairbrush,” that is associated with two companies: “hairstrait” and “kindahairy.” Essentially, it’s a many-to-many relationship, where a hairbrush can be linked to multiple companies.
Previously, the table looked something like this:
| Company | Object |
|---|---|
| hairstrait | hairbrush |
| kindahairy | hairbrush |
In this setup, if a hairbrush was “used,” I’d set a flag in the record to mark it as used. Once marked, the object no longer appeared in the grid.
Now, I’ve updated the system to allow multiple companies to be associated with a single object (like the hairbrush), so I can have several companies linked to one object. But here’s where I need help:
The rule I currently have states that when an object (like the hairbrush) is marked as “used,” it’s flagged in the table as “used.” What I want to achieve now is more specific: I only want the record to be marked as “used” when both companies linked to the hairbrush are marked as “used.”
For example, if the hairbrush is linked to both “hairstrait” and “kindahairy,” I would only flag the record when both companies have been marked as “used.”
So, let’s say this is my table:
| Company | Object |
|---|---|
| hairstrait | hairbrush |
| kindahairy | hairbrush |
If I mark only “hairstrait” as used, the grid would still show the “kindahairy” company for the hairbrush. But if I mark both companies as used, then the hairbrush would be flagged as “used” in the table and would no longer appear in the grid.
I could come up with a workaround for this, but I’m curious to know if there’s a way to set this up directly in the system. Any thoughts?
Thanks!
Regards
Emmanuel Katto