Updating field on a record that has related records.

Hi

Is it possible to update a field in a record which is related to other
records? Or, to update those related fields as well so that they are
still related? (if you see what I mean!?)

Currently, I get the error 'The record cannot be deleted or changed
because table 'xxx' includes related records.'

I am trying to have a temporary number entered into the database when
the end user creates a record and then allow an another member of
staff to replace that temporary number with a proper one.

The field in question is a primary key and an important field to the
whole database.

An example of a similar siutation would be if a member of staff
created an order with a temporary order number with related order
items and then the order number needed to be changed (obviously
without losing the related items on that order).

Alternatively, can anyone suggest a better way of accomplishing this?

Sorry if the above is a bit vague, if more information is required,
please let me know and I'll see what I can post.

Thanks for any assistance.
David

David Andrews wrote:
Hi

Is it possible to update a field in a record which is related to other
records? Or, to update those related fields as well so that they are
still related? (if you see what I mean!?)

Currently, I get the error 'The record cannot be deleted or changed
because table 'xxx' includes related records.'

I am trying to have a temporary number entered into the database when
the end user creates a record and then allow an another member of
staff to replace that temporary number with a proper one.

The field in question is a primary key and an important field to the
whole database.

An example of a similar siutation would be if a member of staff
created an order with a temporary order number with related order
items and then the order number needed to be changed (obviously
without losing the related items on that order).

Alternatively, can anyone suggest a better way of accomplishing this?

Sorry if the above is a bit vague, if more information is required,
please let me know and I'll see what I can post.

Thanks for any assistance.
David

I suggest you should be able to do what, I think, you want to do by
creating a new field for that number that will be corrected and us an
autonumber field for the existing one and hid it so the users never see it.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

"Joseph Meehan" wrote in message ...


I suggest you should be able to do what, I think, you want to do by
creating a new field for that number that will be corrected and us an
autonumber field for the existing one and hid it so the users never see it.


Thanks Joseph

Since posting my message I tried it several ways and have ended up
doing what you have suggested by creating a new field that the user
sees which is not tied by a relationship and hiding the related field
from view.

David

David Andrews wrote:
"Joseph Meehan" wrote in message
...


I suggest you should be able to do what, I think, you want to do
by creating a new field for that number that will be corrected and
us an autonumber field for the existing one and hid it so the users
never see it.


Thanks Joseph

Since posting my message I tried it several ways and have ended up
doing what you have suggested by creating a new field that the user
sees which is not tied by a relationship and hiding the related field
from view.

David

Glad to hear you have it working now.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math