Omit Value from list

[Ben Ball]

I have a table for customers. I have a value list to show all customers from this table within my jobs table.

I wish to omit a customer from the value list but obviously not delete the customer history and relations.

Is this possible?

[Søren Dyhr]

I have made you a template, that sort of make it happen, but it also reminded me of why I tend to make a strained portal for selections instead of popups, well it can kind of work if you not are shy of showing internal ID's but I usually avoid littering a solution with irrelevant stuff seen from a users POW.

The way it works is when you create a new record, will only a scripted access to the field create an updated strainer list, to make the previous chosen dissapear from the selection.

I've put in a timed pause, to avoid being stuck in the popup ...but it's hardly ideal!!! I do usually tend to make my interface use this principle instead:

http://www.dwdataconcepts.com/dl/tw/Many2Many.zip

--sd

BenBall.zip

[comment]

How about marking the customer as archived, and a calculation field:

Case ( not Archived ; CustomerID )

Base the value list on the calculation field instead of CustomerID.