Hello all. I'm sort of new, so if I've done anything wrong, feel free to correct me. My problem is as follows:

I have 2 databases that are related, Employees and Accounts. They are related by a field called Supervisor, so that each supervisor can type in his/her password and bring up all of his/her employees. The supervisor can also pull up all of his/her related accounts. Now I've created an 'account' value list in the Employees database as follows

-It's defined with "use values from a field"

-Only related values: "relationship_name"

Therefore in the it pulls all the 'account numbers' from the accounts database and puts them in a nice value list for the Supervisor to use in the Employee database. This works perfectly in FileMaker!

However, I am also trying to put these databases online. My problem is that I can't get the value list to import at all. I've tried using:

-[FMP-Option]  

-<select name="FIELD">[FMP-Portal: relationship_name]<option value="relationship_name::Acct_num">[/FMP-Portal]</select>

and a few others. All of these options bring up an empty select menu. If I use the FMP-Option and select a DIFFERENT value list, however, it works just fine. I think it doesn't like my value list definition from a Relationship. Anyone got any ideas or thoughts? I'm totally at a loss

Thanks so much if you can give any help!!

Johnny

Related ValueLists do not work through WebCompanion. You can workaround this by using either [FMP-InlineAction] or [FMP-Portal] tags.

For a [FMP-Portal] to work, you will have to name a Layout (-lay) with that Portal on it.

Good Luck.

Garry

WoW! OK, so I knew that you had to specify a layout but for some reason, I didn't do it in this particular case. The FMP-Portal option worked like a charm once I did that. I had tried this method before but I hadn't specified the layout. Thanks SO much for your help.

Jonathan

Hello Jonathan,

I use tag below. I hope it works for you.

<FORM ACTION="FMPro" METHOD="post">

<input type="hidden" name="-DB" value="Employee.fp5">

<INPUT TYPE="hidden" NAME="-LAY" VALUE="Web">

<INPUT TYPE="hidden" NAME="-FORMAT" VALUE="Employee/newreply.htm">

<SELECT NAME='employee' SIZE=1 >

<OPTION>[FMP-VALUELIST: employee, LIST=valuelist name employee]

<option [FMP-ValueListItem]>[FMP-VALUELISTITEM][/FMP-VALUELIST] </SELECT>

This works for me!

Jukkie

Jukkie,

Related ValueLists do not work through WebCompanion!

All the best.

Garry