View Single Post
  #3 (permalink)  
Old October 18th, 2008, 09:54 PM
CoderNH
Guest
 
Posts: n/a
Default

I agree, I would never do this in a normal database application.

I do have a joined table for the categories to manage the listbox. However, I need to take these values from the joined categories table and when the table is updated or when the listbox senses a modification I need to take all the entries in the joined table and make a string of all the values separated by commas and then dump this string into a single field to be read by Outlook when the update engine cycles the database for changes.

Would I use an array to read the values from the joined table and from the array create a comma delimited string and then dump the string into a field?

Can you point me in the direct for the command(s) needed to dump the string into a field?

Thanks


Reply With Quote