Error Message on Relationship Field

[RogerJ]

This may be a little hard to explain, but will try. I have 3 db's that in one form or another have relationships. A membership db, a convenor db and a registry of potential members and members. When a person joins the organization, it creates an entry in membership db from the registry. One of the fields is the region number (from 1-13). It gets this information from the convenor db based on the state. In the membership db, one of the layouts gives all the info that has been autoentered from the registry (no problem so far), all is working fine, including the region number. There is also a layout for membership information: Name, member number, region and the convenor for that region. The Name and member number show just fine. However the region number and convenor do not. When I view this layout in table format I find that the region number and other info is missing. If I try and change the region number, I get the following error. I think I know what it means, but am at a loss as to how to fix it. So, if you can offer some assistance, I would be grateful.

Error is: "This field cannot be modified until "Region#M" is given a valid value".

TIA

RJ

[RogerJ]

This may be a little hard to explain, but will try. I have 3 db's that in one form or another have relationships. A membership db, a convenor db and a registry of potential members and members. When a person joins the organization, it creates an entry in membership db from the registry. One of the fields is the region number (from 1-13). It gets this information from the convenor db based on the state. In the membership db, one of the layouts gives all the info that has been autoentered from the registry (no problem so far), all is working fine, including the region number. There is also a layout for membership information: Name, member number, region and the convenor for that region. The Name and member number show just fine. However the region number and convenor do not. When I view this layout in table format I find that the region number and other info is missing. If I try and change the region number, I get the following error. I think I know what it means, but am at a loss as to how to fix it. So, if you can offer some assistance, I would be grateful.

Error is: "This field cannot be modified until "Region#M" is given a valid value".

TIA

RJ

[RogerJ]

This may be a little hard to explain, but will try. I have 3 db's that in one form or another have relationships. A membership db, a convenor db and a registry of potential members and members. When a person joins the organization, it creates an entry in membership db from the registry. One of the fields is the region number (from 1-13). It gets this information from the convenor db based on the state. In the membership db, one of the layouts gives all the info that has been autoentered from the registry (no problem so far), all is working fine, including the region number. There is also a layout for membership information: Name, member number, region and the convenor for that region. The Name and member number show just fine. However the region number and convenor do not. When I view this layout in table format I find that the region number and other info is missing. If I try and change the region number, I get the following error. I think I know what it means, but am at a loss as to how to fix it. So, if you can offer some assistance, I would be grateful.

Error is: "This field cannot be modified until "Region#M" is given a valid value".

TIA

RJ

[QuinTech]

Is Region#M a calculated field? It sounds like you have a rel. that allows creation of related records, and has a calc field on the right-hand side (the "TO" side) of the relationship.

Jerry

[QuinTech]

Is Region#M a calculated field? It sounds like you have a rel. that allows creation of related records, and has a calc field on the right-hand side (the "TO" side) of the relationship.

Jerry

[QuinTech]

Is Region#M a calculated field? It sounds like you have a rel. that allows creation of related records, and has a calc field on the right-hand side (the "TO" side) of the relationship.

Jerry

[RogerJ]

No, the field is not a calculated field but is defined as a number field.

Roger J.

[RogerJ]

No, the field is not a calculated field but is defined as a number field.

Roger J.

[RogerJ]

No, the field is not a calculated field but is defined as a number field.

Roger J.

[QuinTech]

If I try and change the region number

How do you do this? Are you entering data directly into the right-hand key? Does your relationship allow creation of related records? Please describe the relationship involved here in detail.

I think I know what it means

Well, what do you think it means? Maybe we can propose a fix.

[QuinTech]

If I try and change the region number

How do you do this? Are you entering data directly into the right-hand key? Does your relationship allow creation of related records? Please describe the relationship involved here in detail.

I think I know what it means

Well, what do you think it means? Maybe we can propose a fix.

[QuinTech]

If I try and change the region number

How do you do this? Are you entering data directly into the right-hand key? Does your relationship allow creation of related records? Please describe the relationship involved here in detail.

I think I know what it means

Well, what do you think it means? Maybe we can propose a fix.

[RogerJ]

I got the problem fixed, temporarily. It is not working as I want, but am able to input information and get the desired result. Thanks for your assistance.

[RogerJ]

I got the problem fixed, temporarily. It is not working as I want, but am able to input information and get the desired result. Thanks for your assistance.

[QuinTech]

Well, i'm not sure i really assisted, but you're welcome!

[QuinTech]

Well, i'm not sure i really assisted, but you're welcome!