Filter value list if has been used.

[Hee]

Hi 

 

I would like to know if someone could help me out on this  , sounds simple but unsure what i am missing.

Basically a have a table where i create products - each has a unique lot number.

i have another table which is the packaging lines - i hav another 3 child tables each is a  packaging line.

What i want is be able to apply each lot to a day of packaging and on which line.

I create a page which is the packaging page for Date X , on it i put 3 portals one for each line. I am adding the lot numbers to each line by using a dropdown on the portal.

What i am tring to achieve is that the drop down should filter the lot # which have been applied to a packaging line already , ANy idea how i could achieve that?

 

[comment]

I am afraid I couldn't follow your description, except for this:

3 minutes ago, Hee said:

the drop down should filter the lot # which have been applied to a packaging line already

This is known as a "dwindling" value list. See the demo here:
https://fmforums.com/topic/51074-tough-one-excluding-value-list/?do=findComment&comment=266667&_rid=72594