Good day all - I am attempting to generate a table that holds ONE row for the selected empID on the Subform. So for example, if you select empID abc123 - then I want table ELS to hold data like the below
empID saleItem
abc123 gr1, zz1, fla323
I tried using Allen Brownes ConcatRelated() Function to do this, but I must be using it wrong as the saleItems are not combined, and the insert statement just duplicates the empID for the source table. I am attaching a sample database to illustrate what I mean. If someone here with more knowledge can assist me on why my table is not concatenating ONLY the selected userID I would appreciate it!
Database3.accdb