Jump to content
nexgen

Dynamic value list considering two fields

Recommended Posts

I am a new filemaker user and have already checked several dynamic/conditional value list threads in this forum. However, I couldn't find the solution for my problem.

I want to show the value list according to unique date and not already entered products.

I have created a video explaining what I want to accomplish. Please check here:

https://www.dropbox.com/s/js1rwex9o6a2fv5/01%20Product%20selection%20according%20to%20date.mp4?dl=0

Any help is appreciated.

Share this post


Link to post
Share on other sites

Hi,

You may get more answers by just explaining what you want to have done, perhaps add some screenshots.  That lowers the barrier vs. having to download and video and watch it.  It also us to quote relevant parts of your questions to respond to.

Share this post


Link to post
Share on other sites

Thanks Wim for the suggestion. I thought a short video can explain the concept much easily than in writing. Also, the video don't need to be downloaded. It can be played straight from the browser.

Let me explain my problem here as the way you suggested:

I have two tables:

Products Table

Fields:

_kp_products_id
product_name

Sales Table

Fields:

_kp_sales_id
_kf_products_id
date
sale

In sales table let's say I entered following data:

date as: 2017-01-29 and _kf_products_id as 1

now in the next record if I enter: 2017-01-29 then it shouldn't show "1" in the value list for _kf_products_id field.

How can I accomplish that?     

5 minutes ago, comment said:

I checked the file. It solves omitting already entered product but it acts on whole table. I need to omit the product list in context of the date entered. How can I do that?

Share this post


Link to post
Share on other sites
46 minutes ago, nexgen said:

It solves omitting already entered product but it acts on whole table.

No, it doesn't. It acts in the context of the current contact. In your situation, that would be the current sale. And since generally it's possible to have more than one sale per day, you should rely on the SaleID rather than on a date.

You should also allow multiple products to be sold within the same sale record. For this, you will need a third table of LineItems to act as a join table between Sales and Products - see a basic demo here:
http://fmforums.com/topic/63425-auto-fill-one-field-with-text-from-two-fields/#comment-300150

 

 

 

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

  • Who Viewed the Topic

    2 members have viewed this topic:
    reynir  DavidTO 
×

Important Information

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