List of certain values of a value list

[Symont]

Hi there, I'm trying to create something like a "condition list of value list".

Basically, i'm creating a value list of everything in certains fields (no problems yet). What i'd like to do, is to have a list of every element of the list that are in one particular record, and omit the elements of the list that are not in.

Example: I have a value list of about 100 books for ALL the records in my BD. I'd like to to see every book that are listed in only ONE record (let's say there is 25, the list would only show these 25, and not the 75 others).

Basically, it means that every record would have a different list of the books comming from the same value list.

Is it clear what i'm trying to do? Can someone help me with this?

Thanks

[-Queue-]

Why would you have 25 in one record? Are you perchance using repeating fields or multiple instances of the same field (e.g. Name1, Name2, Name3) to hold your data, instead of related records?

Also, what version are you using?

[Symont]

I have a value list for the entire BD. The thing is that not every value of the list is used in each record. I'd like to have a list of the values that are used only in ONE record (the 25 is only an example). With this list, i'll be able to know exactly wich values are used in each records individually, and have the entire list of values for the entire BD.

I'm using FMP 7.0v1 (not dev)

[-Queue-]

And why does each record contain more than one value? Or do you mean you have a field formatted as a checkbox from which you can select up to 100 items? If that is the case, you can either format another instance of the field as an Edit box, or, if you require they be in alphabetical order, create a self-relationship based on the unique serial field (I will denote it as Table 2), then create a value list using the related field formatted as a checkbox (Table 2::textField), 'starting from' Table 1. Then you can use an unstored ValueListItems calculation to display the sorted, related values.

If that is not the case, I would suggest you use a related table to hold each value, with one record per value, and a similar value list to retrieve all related items.

[sbg2]

Its still unclear what you want and how your database is currently setup. Post a mock up database so we can have a better idea of what you are trying to do.

The current version of FM7 is 7.0v3, you may want to update to the latest version.