Enumlist as list of resources for other child enumlist

AppSheet AppSheet Q&A
1

I have following main sheets: RESOURCES, EVENTS and CHILDEVENTS
Event table has an enumlist (REF) field pointing to resources list, once I have created this resources list for that event, I want to create for that some child events with other enumlist field
I would like to assign each resource from event to child events, as example

  • Resources = {1,2, 3, 4, 5, 6, 7}
  • Event 1 = {1, 2, 3, 4}
    -Event child 1 = {1, 2}
    -Event child 2 = {3}
  • Remaining Event = {4} without assignment
    I am not be able how to face this problem, and sugestion or idea will be welcome
    Thanks a lot
2

Just clarity, main challange here is, when I try to take items for Event Child2, it will be possible to choose free items from parent Event1, I mean, in that example, I could select of {3 , 4 } but never {1, 2} because they were reserved on Event Child1

3

You need to subtract the event child list from your event list for that purpose. i.e.
{1, 2, 3, 4} - SELECT(TableName[Event],[Event] = [_THISROW].[Event])

4

But, How can I reference to that enumlist field result from child event to event list? Only allow me refence to table
Thanks a lot