portal error: "invalid" table relationships

[picnichouse]

Hi,

I'm getting an error in a very complex Fm database I'm working on. I am in TableA and there is a portal to TableB. There is a relationship from TableA to TableB via Field1. The relationship allows new records to be created in TableB from TableA. When I'm in a TableA layout trying to enter records into a portal to TableB, I get this error:

"This operation cannot be performed because one or more of the relationships between these tables are invalid."

Anyone know why I might be getting this error? It's making me crazy!

Thanks,

Andrew

[SlimJim]

I'll ask the obvious questions in case you have overlooked one of them.

1. Does the match field Field1 have a value in TableA?

2. Are you entering data into an empty row in the portal?

3. Is Field1 the only match field between the two tables?

4. Have you tried scripting part of the data entry to see if that works?

[IdealData]

Possibly you are using an unstored calculation, a global or a related field as the match field in the target of the relationship.

FMP won't let you declare a relationship like this, but you could have modified the the target field since then.