calculated lookup not working from WPE

[Hal Jenkins]

I have a field that has a calculated Auto enter value, which is the value of a calculated field in a related table. When I create a record using FileMaker, this works fine. When I create a record using WPE (PHP pages), the auto enter does not work.

I have tried doing a calculated Auto enter value, which is the value of a non-calculated field in a related table and this works fine. So it appears to be something to do with the related calculated field!?!

Does anyone know why this is and how I can fix.

Thanks

Halski

[Søren Dyhr]

So it appears to be something to do with the related calculated field!?!

If the calculated field depends on a global or a value a ralation away is it going to be unstored, and unstored fields that haven't been brought to action by a layout event in the layout the cursor is in does it carry null values.

So what you attemps to do is based in an inadequate database structure, and should be solved differently!

--sd