which field shows as "antibiotics" in your screen shot? TSMod?
Seems like you have a category (Antibiotics) and members of that category (Gentamicin, Cephalosporins, etc.)
Looks from here like the Category (TSMod?) could be in one table and the members (TopiceName?) in another, related table with a one to many relationship from the category to the memers.
Hi Phil - thank you for helping. "antibiotics" is the field TopicName, as are "gentamcin" "cephalosporins" "aminoglycosides" (apologies TSMod and CreateDate are my autoenter modification timestamps and creation date fields respectively). I don't want a category-member arrangement. I want to be able to reference one topic from another (kind of like a 'keywords' link in a blog post etc). In this example, the list of gentamicin cephalosporins and aminos do happen to all be antibiotics or types of antibiotics, but I might equally want, in another record, to link "train" with "beach ball" with "moon dust". Does that make sense?
Hmmm, in which case back to the suggestion I almost posted the first time:
Your return separated lists functions as a kind of "mini join table" all in one field. Why not take the next logical step and use an actual join table in your self join relationship? The join table can be easier to update and you then have the option of basing report layouts on the join table.
I've done exactly as you suggest. I hadn't thought of having a join table linking two occurrences of the same table. Thank you Phil.