Hello I am trying to list associated values in one field as filtered by a query, but a little more complicated in the presentation of this information. Here is an example:
TBL-1
ID: EMPLOYEE: LOCATION:
== ========= =========
1 Hernandez New York
2 Brown Arizona
3 Valdez California
4 Smith Utah
5 Salisbury Utah
These are put in another grouping:
TBL-Group
ID: GROUP:
== ======
1 Sales
2 Marketing
The group forms a parent relationship with the employees as the child. That being said, I want to create a query that allows me to list the groups and then list the associated locations in one listbox, but this list is a combination of the values all separated by a comma.
Like this:
QRY-Locations
ID: GROUP: LOCATIONS:
== ======== ==========
1 Sales New York, Arizona
2 Marketing California, Utah
Thank you! Can this be done??
TBL-1
ID: EMPLOYEE: LOCATION:
== ========= =========
1 Hernandez New York
2 Brown Arizona
3 Valdez California
4 Smith Utah
5 Salisbury Utah
These are put in another grouping:
TBL-Group
ID: GROUP:
== ======
1 Sales
2 Marketing
The group forms a parent relationship with the employees as the child. That being said, I want to create a query that allows me to list the groups and then list the associated locations in one listbox, but this list is a combination of the values all separated by a comma.
Like this:
QRY-Locations
ID: GROUP: LOCATIONS:
== ======== ==========
1 Sales New York, Arizona
2 Marketing California, Utah
Thank you! Can this be done??
