GPGeorge
George Hepworth
- Local time
- Today, 04:52
- Joined
- Nov 25, 2004
- Messages
- 3,304
You may have missed the post where the OP mentioned the new owner is interested in products active in the previous two years. That is history.
Solved Table Updates - PK changes - help
- Thread starter wmix
- Start date
Gasman
Enthusiastic Amateur
- Local time
- Today, 12:52
- Joined
- Sep 21, 2011
- Messages
- 17,520
Fair enough then.Thanks Gasman, yes, he's seen it working, with some questions about "why" does it do this not that, etc.
I'm trying to do the "fixes" he's asking me about. Right now, it's just myself and our current owner who use the program, so it's not really an end-user type of deal. I need to add a lot of forms and a better working menu so the new owner can find what he needs quickly and without messing things up on the back end
- Local time
- Today, 12:52
- Joined
- Sep 12, 2006
- Messages
- 16,096
I've not read the whole thread, but surely a few product descriptions doesn't matter
Add a column, number probably
Mark the active items as 1
Mark the archived items as 2
Mark the redundant items as 3
Then you can cascade delete all of the "3" records, and any related records, deal with the "2" records as you need, and leave the "1" records untouched. Work on a copy of the data of course.
You should be able to use the related sales data to automatically "tag" the products you want to keep and/or delete.
As you only have 250 products you can even inspect the results manually, I should think.
Add a column, number probably
Mark the active items as 1
Mark the archived items as 2
Mark the redundant items as 3
Then you can cascade delete all of the "3" records, and any related records, deal with the "2" records as you need, and leave the "1" records untouched. Work on a copy of the data of course.
You should be able to use the related sales data to automatically "tag" the products you want to keep and/or delete.
As you only have 250 products you can even inspect the results manually, I should think.
Gasman
Enthusiastic Amateur
- Local time
- Today, 12:52
- Joined
- Sep 21, 2011
- Messages
- 17,520
I hope he is paying for the mods.Thanks Gasman, yes, he's seen it working, with some questions about "why" does it do this not that, etc.
I'm trying to do the "fixes" he's asking me about. Right now, it's just myself and our current owner who use the program, so it's not really an end-user type of deal. I need to add a lot of forms and a better working menu so the new owner can find what he needs quickly and without messing things up on the back end
or that is part of the selling contract.Not enough.I hope he is paying for the mods.
