Table Updates - PK changes - help (2 Viewers)

[GPGeorge]

Nope.

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.

 

[plog]

You may have missed my quote marks:

I don't understand the premise. Why not copy the database and just delete everything 'inactive' related and give him that copy?

My advice stands, but keep trying.

 

[Gasman]

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

Fair enough then.

 

[gemma-the-husky]

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.

 

[Gasman]

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

I hope he is paying for the mods. or that is part of the selling contract.

 

[BlueSpruce]

Just remove what data that is not required.

Don't remove any products! There's most likely other related records, like open invoices and sales that depend on those products. Removing them would orphan records and break your app. He might want all or some of them later on. 250 products is not a lot of records. For starters, filter out the one's he said he didn't want in all applicable queries. You don't know when new owner might say "Hey, those products I told you not to include, well, I want them now...". Or the current owner makes a deal with the new owner to allow him to work with the products he previously excluded from the deal. The words "Never" and "Always" are not in my vocabulary.