Hi
Big problem here, I have a multivalue text field called "Groups" that is generated through a relationship
with another table called "Comments". When I set this up I left the field as a text field when it should
have been a number field, and now I can't use the database with sharepoint, because the field needs
to be a number field.
My Question is there a way to convert it without loosing all my data, as there are over 5000 records?
My Table with the multivalue field is called "Contacts", the field is called "Groups".
I tried update and append queries but I must be doing something wrong, so detailed explanation would
be very much appreciated.
Thank You