value lists & related fields

[clevow]

Okay, I'm going a little crazy. I've read through a bunch of the posts on displaying a value list that is based on related values and I'm still not able to do what I need.

I've got a database that is essentially a clothing inventory/availability. I have a value list called "sizes" which contains all the available sizes for all items in the database. In the db this is displayed as check boxes. If an item is available in a particular size, the checkbox is checked. I have another value list called "colors" which works in the same way, except that I have the value list based on fields from another table.

Now for the web side... using custom web publishing, FMP5 unlimited on Windows XP-

Ultimately, I want the user to get a list of available items and then choose which they want and in what sizes and colors. The first hurdle that I need help on is this. How the heck can I get the appropriate sizes (and colors) to show up in a value list? I don't care if it's a drop down menu or radio buttons. I just want the user to only see, and be allowed to choose, sizes and colors that are available.

In the various iterations I've tried, the closest I've come is using a portal. My problem here is that all the available sizes end up displaying on one line, as one option. I can't get them to be separate values.

I've also tried a calculation field using the design function "valuelistitems" but had no further success.

This database is not very big, so any suggestions, including redoing the relationships and such are welcome.

TIA,

Carrie

[Pupiweb]

Try with an Inline

<Select name="FieldName">

<option value=""> Select a value

[FMP-InlineAction:-db=Items.fp5,-lay=cgi,Item={field:ItemID},-max=all,-find]

[FMP-Record]

<option value="[FMP-Field:Size]">

[FMP-Field:Size]</option>

[/FMP-Record]

[/FMP-InlineAction]

This will produce a list of the sizes related to an item; with a similar mechanis you can also get radio buttons, checkboxes etc ...