Jump to content
Sign in to follow this  

Duplicate values in a valu list

Recommended Posts

I have Two fields named location. Location_1 and Location_2. Basically when an address is entered a location type needs to be assigned to it.

Location field has a value list assigned with 4 possible location types: Main, Billing, Shipping and Other.

So when an address is entered the location is chosen.

I set up one more calculation field (Location_calc) which calculates Location_1 & Location_2. I made one more value list which displays values from that calculation field.

In my invoice layout a new field which has a value list assigned to it (value list that shows values from Location_Calc field). When a value is chosen the address fields on invoice get automatically filled (autoenter calc, do not replace existing value).

The problem is that when I have a couple of customer records the location types repeat.

So the value list starts displaying Main, Billing, Main, Other, Billing and so on based on how many records I have in customer table.

How would I get rid of the repeating values?

I got myself confused with this post so if it is too confusing please let me know and I will try to explain better, attach examples.

Thank you.,

Share this post

Link to post
Share on other sites

Never mind, it only shows all of the possible locations, it does not duplicate them.

Was looking at the wrong place.

Thank you.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.