July 23, 20205 yr 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?
July 23, 20205 yr 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
Create an account or sign in to comment