Newbies Masood Bacchus Posted December 21, 2012 Newbies Share Posted December 21, 2012 I'm using Filemaker Pro Advance 10 to make a simple invoice for line items of different products, each with varying colours. I, however, can not seem to get it to work. I created a table of products, whose layout has a portal to another table. This is where, using a drop down list, the varying colours of the product are input. The colours are listed in yet other table. Some products can have a limited number of colours while others have access to all colours. Ideally, on the invoice, by line item, The product is selected in one field and then one of the colours relevant to that product is selected from a drop down list. How do I make this happen? I have tried doing a conditional value list with no luck, but I believe I am lacking something. Please assist if possible.... Link to comment Share on other sites More sharing options...
comment Posted December 21, 2012 Share Posted December 21, 2012 Assuming you have: ... LineItems >- Products -< ProductColors >- Colors define a value list using values from Colors::ColorID, include only related values starting from Products. Link to comment Share on other sites More sharing options...
Newbies Masood Bacchus Posted January 18, 2013 Author Newbies Share Posted January 18, 2013 Sorry for the late reply. Your information was helpful and I solved it. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4137 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 accountSign in
Already have an account? Sign in here.
Sign In Now