ValueListItems(..) only record distinct item?

[H.P.]

Hi all,

I'm trying to use valueListItems(relatedField) to record data from a related field. However, this command only return distinct items. The function will ignore any item that is similar.

For example: If I have 2 items: "01/01/04" and "01/01/04", valueListItems only record one "01/01/04" and ignore the other.

Does anyone know how can I get around this problem?

Thanks,

H.P.

[gmmac]

Hi

I had a similar problem just trying to bring up a list of values through a value list (not a related field). I ended up using a portal, but that happened to work nicely for my particular solution.

Off the top of my head, only other thing I can think of is to use a concatenation to combine that field with another which will make it unique. You'd have to figure out how to return it to the original value you want--with how you display your value list, through another calculation, etc. It's not necessarily pretty, but will it get thejob done? Maybe someone else has already discovered a more elegant solution.

-G

[H.P.]

Thanks for your help, Galen. Apparently valuelist will only return distinct value.

I just found the solution to my problem. Instead of pointing the value list to the item I want, I changed the value list so that first field of the value is based on unique id and the second field is based on the value item I want. Then I can filtered the unique ID out B)

[gmmac]

Ah--that sounds good.

did you filter out with right words and a new calc field, or some other way? I _really_ dislike Access but I do like that you can choose which field to enter from a drop-down list.

Let me know if you can,

thanks,

Galen

[H.P.]

Actually, I used 2 fields to do that... the first field has the unique ID (which will be from a drop down list. The second field is related to the unique ID. I hided the first field by making it transparent and only display the second field.