What's up with this relationship?

[SteveGriff]

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

[djgogi]

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

[Kurt Knippel]

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.