Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6164 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

hi. happy new year to all.

is a table i have name of customer and tape of customer. how can i make a drop down list that it will show me all the customer that are in tape "a"?

Posted (edited)

The file didn't come through.

Be sure you follow the steps.

Zip your file.

Click on [color:orange]Manage files.

In the Popup Menu,

Choose File locate the file that is zipped on your hard drive

Add File You will see it work, and then add it to the list in the box

Finish Be sure to click this button, or it will not add the file to your post

Add Post

HTH

Lee

Edited by Guest
Posted

I had the same issue. This is what I did.

I made a value list. choose values from another field/pick the field that has the data you want to see. That way when you add data to that field, it will automatically go into the value listing.

Posted (edited)

Hi Kevin, :smile2:

The only reason I didn't attempt an explanation is that dani was already given a sample to follow AND dani didn't provide much in the way of explantion of what had been tried, what didn't work, or what was confusing.

You've helped out before, thank you so much. But I don't want you to think I was blowing off dani's need; it's just that sometimes it's easier to ask for a file, fix it for them, then explain how it works in THEIR file rather than post back and forth another 10 times since dani was so thin on providing information. This felt like one of those times. Thank you for catching (and carrying forward) the ball for us here! :wink2:

I'll bet it's cold in Great Falls right now! We have (I think) 68 degree days here!

LaRetta

Edited by Guest
Posted

You must have selected the wrong type file to download? If you select Windows, you will get a zip file. If you select the blue mac icon, you will get a SIT file. One or the other should extract for you.

But to your issue directly ... you must have a filtered relationship to specify a conditional value list. Since you want to only display customers with Tape A (type of hotel) then you need to base your relationship on a table occurrence of customers which has been filtered by Tape (see your graph). A global is created in Customers but that global is placed in PriceLists. You must select the Tape (yellow field) and THEN select the customer which will now filter down for you. Notice in your value lists that I changed your CustomerID value list to, instead of specifying 'all values', to 'Only related values' starting from 'Tape of Customer'. :wink2:

LaRetta

Copy_of_pricelist2008_2.zip

Posted

Well I'm just guessing but it says "here i what to see only cutomer that r in hotel type " on the layout. And upon reviewing the detail, type makes sense when I read the value lists. But yes, it threw me off bigtime as well at first. I created the global and followed the same 'logic' just to be sure I didn't confuse even more. It is quite possible that english isn't the first language here and that's wonderful as well. :wink2:

This topic is 6164 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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