Partial Value-List?? OR how to get selective data in there...

[e007]

hello,

The "Scenario"

I have a table for my CRM System which keeps ALL adresses regardless of the type (supplier, customer, subcontractor,....) called "Address"

There is a field "isSupplier" in that table which either says "Yes" or "No" whether the entrie is a supplier or not.

Now there's a Table for my Products called "Products"...

For each product I want to be able to choose my main supplier from the "Address" table described above and have it associated.

to accomplish this the Products table has a "SupplierAddress_ID" numeric field which can contain the AddressId of a supplier.

I want to create a ValueList which should show all Entries from the Address Table which have a "Yes" in the "isSupplier" field...

However no matter what I trie, the DropDown which should show the contents of this ValueList always shows ALL entries of the Address Table...

How can I make a Value-List containing only those entries of the Address Table which have a "Yes" in their "isSupplier" field?:

Thank you!

[Fitch]

Hello, e007 -- if that is indeed your name : -- welcome to the Forums.

1. Make a calculated field in Products, let's call it "Y," whose calc is: "Yes"

2. Make a relationship from Products to Address based on Y to isSupplier

3. Define your value list to only show related values using the relationship you just defined

Note: my preference is to use a value list of "1" for all fields concerned, rather than Yes/No, it simplifies things in more ways than one.