Search results

  1. R

    Query to combine "Users" and "Groups" into a single table

    Hi, sorry for the delayed reply. A person can be in more than one group (e.g. a person can be "Parent" and "Home Owner" or "Child" and "Home Owner" or just "Home Owner"). The management is only hard if you think of the groups from the bottom up rather than the top down. It's better to think...
  2. R

    Query to combine "Users" and "Groups" into a single table

    Hi, The reason is actually really simple. Let's say I want to create an event (e.g. "Plan summer holiday"). That may be owned by me (e.g. "Dad" a person not a group) but I may need to ask opinions (e.g. "Family" a group). So I create a form from in which I create the event, assign it, and...
  3. R

    Query to combine "Users" and "Groups" into a single table

    That's really helpful, thank you very much. I'm going to see how it performs when updates are made to either the Groups table or the People table. Fingers crossed. Thank you very much again.
  4. R

    Query to combine "Users" and "Groups" into a single table

    Hello both of you and think you for your kind replies. Let's say I have 3 People, Alice, Ben and Chris and I have 2 groups Parents and Children. I just want one list: Alice Ben Children Chris Parents I have looked at Union queries, but unlike the other queries they seem to need manual...
  5. R

    Query to combine "Users" and "Groups" into a single table

    I've got a table called People. Each person is unique. I've got a table called Groups. Each group is unique. A person can be a member of multiple groups. Not every person is in a group. Groups can have multiple members. A group can also be a member of another group (e.g. "children" and...
Top Bottom