Updating field on a record that has related records.

  • Thread starter Thread starter David Andrews
  • Start date Start date
D

David Andrews

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 said:
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
Click to expand...

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 Meehan said:
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.
Click to expand...


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 said:
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
Click to expand...

Glad to hear you have it working now.
 
Back
Top