Re: Multivalued Fields
I prefer to avoid multi-valued fields simply because they make it more difficult to work around than just having your own table which stores the values. Yes, it makes for a nice interface, but when you start needing to do things with the data it can become a pain.
When you use a multi-valued field you need to select that as the datatype. It then stores the data as a variant. Also, you really should avoid using the lookups directly at table level (outside of the multi-valued fields).
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.