Showing related fields as checked boxes.

[joseppic]

Hi,

I'm adding associated records via a portal - fine.

The client has asked for these associated records to be displayed in the main view as a list of checked fields as they like check boxes. These check boxes will be read-only (records created via a layout with a portal, but displayed in another summary layout as checked boxes).

I've got a VL of the assoiated fields, but when I insert the assoc record and apply the VL as read-only check boxws I only get one field (obviously).

Any ideas how I should be doing this?? If I use a portal - each portal row has the full set of check-boxes with the appropriate one checked. I just need one set of check-boxes with a check (read only) for each record I have associated.

Do I need a calc look-up in the master table which stores multiple values?

Any ideas welcomed.

thanks,

J.

[Pupiweb]

Create a relational value list for each field in the portal, using the same relationship used for the portal, pointing each list at one of the fields with the checkboxes

So if you've chosen values like

Apple

Orange

in the related records only these values will be part of the list

Obviuosly you'll see Apple checked in the first portal record and Orange unchecked, and the reverse in the second portal record

If you need to see only the chosen items as checked checkboxes create in the related file a self join relationship based on a unique recordID and use this relationship to create a relational value list

Then in the master file create a series of value lists and set each to "Use value list from another file", choosing the appropriate self-relational value list in the related file

[joseppic]

Hi, I'm still getting lost I'm afraid.

In the master file I would like a set of check boxes. One check box for each possible value of just one field in a related file. Where the field is related (i.e. there is a one-to-many for this particular master record) I would like the box to be checked.

e.g.

Fruit.fp5 = orange,apple,pair,cherry

my_Fruit.fp5:

[x] orange

[x] apple

[ ] pair

[ ] cherry

In the above, a record in my_Fruit.fp5 has two records assoc in Fruit.fp5

The assoc records have been created via a portal in a different layout, but I would like a summary layout displaying the above.

thanks,

J.

[Ugo DI LUCA]

Hi,

Is this what you're looking for ?

Checkboxes.zip