Getting Rid of Multi-Value Fields

[raychow22]

Hi Forum,



I have been getting rid of my multi-value field data by separating them in additional combo list "Fields". I was wondering if there is a code I can put in where a combo list drops into my Form Field and then separating it with a ";" causes a new combo list drop (within the same Form Field). Is that something that can happen?

The point is that I want a combo list drop to make it easy to type in additional combo list items without having to write the whole thing out.

Thanks,

[raychow22]

This is an example, Location 1: "S1;WA2;Zone A (0.00-0.09)" is row sourced from another table. If i put a ";" after that am I able to regenerate the combo list again to easy pick out another item on the list?

[CJ_London]

not in a combo control. you can only select one value.

It's not clear to me what you are trying to achieve and looks like you are working with denormalised data- usual way would be to use a subform

[raychow22]

not in a combo control. you can only select one value.

It's not clear to me what you are trying to achieve and looks like you are working with denormalised data- usual way would be to use a subform

Ajax,

What i'm trying to achieve is that there can be multiple locations, but I want to capture them into one field vs. many fields. I'm really trying to avoid using multi-value fields. Do you think using many fields is better?

[June7]

If these are multiple locations, should be multiple records.

A multi-value field is really multiple records. Access hides the table.

Comma or semi-colon separated values is not an improvement over multi-value field.

[CJ_London]

Multivalue fields do not store the data in one field - it is just presented that way.

To achieve the same effect for presentation from a table, google 'concatrelated' which is a function with returns multiple values in a single string.

However it would appear your issue is not the storing or presentation of the data, but the capture.

It can probably be done by visual trickery - perhaps have a combo 'selection' control overlaid on top of a 'presentation' text box but would be a complex way of doing what you want.