Duplication Data Reload

[munkeyroot]

Hey everyone
i'm not sure how to tackle this one
i have a duplication script (attached) which i run to copy whatever is in the main ID at that time.

there is a parts list within this main_id which is built from drop downs and other tables inc a third party table.
anyway issue is when this gets duplicated it the parts list obviously copies whatever is in the current Main ID.

which this is ok. however the main parts list prices gets updated regularly so if a duplication is needed it only copies the parts that are in that and we have prices issues.

is there a way or method when the parts list gets duplicated it will reload the parts without manually reading them to pick up the new prices etc.

this probably doe snot make sense
but hope you can help

Munk

 

[isladogs]

First of all, why are you duplicating records at all?
That goes against basic database principles.

Secondly if you must duplicate for some reason, can you:
a) automatically assign the new ID value
b) use referential integrity with cascade update to simplify adding records to each table

Thirdly is 'doe snot' fundamentally different to 'stag snot'?

 

[munkeyroot]

HI isladogs

Yeah i know fella, who i'm i to argue with my boss lol.

yes the duplication automatically assigns a new ID, however i cant seem to change the join on the qry to referential integrity with cascade update they are grey'd out