I am currently working on a meeting agenda/task DB for our department. As it stands now we have an 'issue' that can have more than one owner.
I have written a simple method to create a string of the owners and store them in a list box on a main string. Problem is tht I am using a query as a recordsource for this listbox and it is running through the method for aach record. needless to say this is creating a significant amount of overhead.
Does anyone have any suggestions/idears on this?
My thoughts are to create an additional field in the Issue table to store the string that is the owneer(s) for that issue, then updating it each time an issue is changed.