Comparing one list against another to create a third

[Toby B]

Is this possible?

I have a set amount of unique values that I want to create a Value List from (These values are IP Addresses).

Pretty straight forward you say ... a Custom Value List.

I then want a Value List that contains only the IP Addresses used so far.

Again you say ... Simple, use a Value List generated from the IP Address field.

The point where I get confused is here ...

I want the user, when assigning a record an IP address, to choose from a third Value List.

This third list is the same as the first list, except, it has been stripped of all the IP Addresses already used (the second list).

Can anyone give me a point in the right direction?

Thanks in advance.

Toby

[Kurt Knippel]

quote:

---

Originally posted by Toby B:

Is this possible?

I have a set amount of unique values that I want to create a Value List from (These values are IP Addresses).

Pretty straight forward you say ... a Custom Value List.

I then want a Value List that contains only the IP Addresses used so far.

Again you say ... Simple, use a Value List generated from the IP Address field.

The point where I get confused is here ...

I want the user, when assigning a record an IP address, to choose from a third Value List.

This third list is the same as the first list, except, it has been stripped of all the IP Addresses already used (the second list).

---

Something that you could do is to store the "All IPs" and "Available IPs" value lists in global fields. Get the "Used IPs" value list from the actual IP Address field in the database.

When the user clicks on the field to choose the IP address a script is actuall run, which uses the Troi Text Plugin to populate the "Available IPs" global with the results of the subtraction of the values in the Used IPs value list from the All IPs value list. Then it would use the Goto Field command to actually activate the field.

This is just ONE wayt to do this.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=