G
Gary F Shelton
Want some advice on how to design some data. I have created an inventory table.
In the table it has many fields which provide good reference points. I now
want to have a new field "Go Sell" that is as simple as telling me a yes or
no indicator.
The issue I have is this. In the inventory table there are sku's that are
discontinued, damaged, past shelf life, approaching shelf life, on quality
release staus, etc etc etc... that are ready for sale. In my new field "Go
Sell" how would one advise that I write the many different append queries to
the new table as I don't want to do this manually?
In the table it has many fields which provide good reference points. I now
want to have a new field "Go Sell" that is as simple as telling me a yes or
no indicator.
The issue I have is this. In the inventory table there are sku's that are
discontinued, damaged, past shelf life, approaching shelf life, on quality
release staus, etc etc etc... that are ready for sale. In my new field "Go
Sell" how would one advise that I write the many different append queries to
the new table as I don't want to do this manually?