Generating a Checklist Based on a Portal

[keshalyi]

Hi all!

I've got another little stinker for you guys and gals out there in FM land.

Is there anyway to generate a checkbox list from a portal? I have a database where I am scheduling classified ads, and there is a table of all the different newspapers that they may be printed in, right now there are seven papers. Then another table stores all of the scheduled instances of this particular ad, different combinations of publication and date.

So I have a portal now that lists every publication that an ad will be printed in. What I WANT is a list of checkboxes, one for each possible pub, filled or unfilled depending on whether or no the ad will print in that paper. Is there a way, maybe, the values of a field within the portal into a carriage return delimited last? In other words, if I have three records in the portal, where the first one has a value in its pub field of A, the second of B, and the htird of C, can I make a calculation field that wil equal

A

B

C

:?

[Kurt Knippel]

Create a value list using the Names of the papers from the other file. You can then use this value list to display as a checkbox

[keshalyi]

This part I know!

The problem becomes - I can generate the checkboxes themselves. How do I fill them? Somehow, I need to have the checkboxes with a corresponding instance display as filled.