Tables are invalid?

[The Missing Man]

I have a data base that has different tables in it.

Table A is linked to Table B and works just fine.

Table B is linked to Table C and works just fine.

Now I am copying info from Table C to Table A and I am experiencing problems.

It's weird because I was just using a set field through a script and received the following;

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

Can someone explain this to me please.

I then tried just grabbing a portal and populating the information that way. The constant fields transfer over no problem.

But the number fields or date fields (seeming anything that has variable data) is coming in all wrong. I have no idea what or where the numbers are coming from as they don't related to the record in question and are not constant in how they are coming in. Sometimes it looks like the numbers are adding up and then other times it's off by only $20 or so. I am not sure if any of this makes sense to anyone as I am confused.

Any help appreciated, thanks.

[comment]

Some information about the tables and esp. about the relationships between them would be useful.