Jump to content
Sign in to follow this  
Anuviel

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    siroos12 
×

Important Information

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