1 of 1 people found this helpful
You really need to describe the data model that you have set up for this. A screen shot of the relationships would be helpful. Even more helpful would be to include a description of how the different parts of that screen shot work with regards to your layout.
For the purposes of this, assume that these are two unrelated tables. There are more fields in these, but I've simplified down to the ones that are relevant to this problem:
Table 1 (Lighting Instruments)
Table 2 (Groups)
Group Content Type
Here's what my groups list looks like:
So to create a new group, you can choose a content type, and then a label. Then the "get contents" button will run the following script, which searches through the Lighting Instruments table, gathers ID numbers, and dumps them into the contents field.
The reason that I need plaintext ID numbers in this format (1+2+3+4) is because this data gets sent to a theatrical lighting console and that's the only syntax that it will accept for this. That's why this field exists and is formatted this way and isn't just a portal with a relationship between the tables.
Now, what I'd like to be able to do is to have more levels of automatic group creation:
On this screen, the relevant boxes are "filter" and "by." In this example, I first want to find all of the lights that are in a particular color, and then create x number of groups based on the "by" field (position). (Note: these search boxes are global records in a separate "Tools" table)
So going back to my original post, let's say that I have 100 lights, 9 of which are blue, in three different positions of three lights each. Creating the group of the 9 of them is no problem. It's then finding how many unique "Positions" there are in that group of 9. Then, cycling through those unique positions and inserting the ID numbers into new records on the "Groups" table.
Not linking this data in a relationship makes no sense. The list of ID's you describe can be produced via a relationship so that is not a reason, by itself, to not set up a relationship. Such a relationship might make this process simpler and easier to manage.
But I'm using my phone to respond and that's making it too difficult for me to provide a more complete response to the info that you posted.