0 Replies Latest reply on Dec 6, 2010 10:30 PM by gizmocreative

    Conditional Value List - having a heap of issues

    gizmocreative

      Title

      Conditional Value List - having a heap of issues

      Post

      Hi There

      I have been reading tutorials all day and my database does not seem to work with the conditional database being the issue.

      I have a relationship in my database which is straight forward

      line items >- products

      and i had a pop up menu (product category) in the product table that used custom values and then had the same menu available in line items so when selecting a product category., the second pop up menu (product name) would auto populate with the products from that category. it was all fine, but i realised the way they were related was all wrong, i believe the tables were related by category which is a big no no, plus choosing a category brought up a price for the product and choosing a product from the next product menu didnt change the price.

      so I rethought my strategy and found a heap of tutorials and came up with the following solution:

      line items >- products : related by productID

      line items >- sales category -< products_bycategory : all three related by salescategoryID (products_bycategory is a TO of products)

      so in the line items layout i have a pop up menu that gets its values from the sales category table (salescategoryID 1st & category name 2nd)

      the second pop up menu is supposed to be populated from the products_bycategory TO (salescategoryID 1st & product name 2nd) include only related values starting from (Line items)

      this pretty much duplicates the demo file i got from a tutorial that works, but im getting <No values defined> in the second pop up menu

      can someone let me know if im doing something wrong?

      i have attached the file, i have made this database from scratch, let me know if it is pretty much ok as far as structure if you will

      thanks!