January 3, 200818 yr 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"?
January 3, 200818 yr Hello Dani, Have you tried the "Value List"? From "File --> Manage --> Value List"
January 3, 200818 yr Author yes i did. it shows me all the record in the table i what to see the ones the are in customer type "a"
January 6, 200818 yr Please attach your file to a response here so we can see what you have. :smile2:
January 7, 200818 yr 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 January 7, 200818 yr by Guest
January 8, 200818 yr 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.
January 8, 200818 yr Hi Kevin, 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! I'll bet it's cold in Great Falls right now! We have (I think) 68 degree days here! LaRetta Edited January 8, 200818 yr by Guest
January 8, 200818 yr Yep, not a problem. I just wanted to get my 2 cents in.lol... It is 26 right now... and feels like snow soon again:(
January 8, 200818 yr Author LaRetta thank you for tour help so much the problem was that the link that i got dose not open for me.
January 8, 200818 yr 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'. LaRetta Copy_of_pricelist2008_2.zip
January 8, 200818 yr 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:
Create an account or sign in to comment