Hi people,

I just don't understand why this relationship doesn't work when used in a portal and I try to create a new record through it: -

myDatabase::cOne = myDatabase_LineItems::cOne

cOne in both databases is a calculation that returns number 1. This is used to show all line items in all records.

But everyttime I try to create a new record through the portal I get:

"The relationship "foobar" is not valid and must be corrected before this field can be modified."

I don't know why it's happening, I have a normal primary key field and two other text fields that are edited through the portal - hope someone can show me the light!

Thanxs!

Steve Griff

The right key (the one in related DB) can not be calculated to allow creation of related records.

Instead use Auto enter calculation 1 (or auto enter data 1) and prohibit modification of value.

Dj

A better idea is to NOT allow creation of related records based upon a Constant relationship, but instead create records on a more logical relationship.