This maybe a simple problem but it has me stumped..!
Single user ver 5.0
I noticed today that my inventory is lacking 18 part numbers. When I look for them in the Inventory form they all come up missing.
If I go to the stock table it shows 72 part numbers by count but only 54 are visible. When I do a query on the stock table all the
part numbers come up including the missing 18. If I run a filter in the inventory form they come up. But if I do normal "locate value"
lookups they will not come up and I have been going crazy trying to figure it out. This will eventually cost me a bundle in sales
if I don't know what I have in stock..
I have tried checking all the possible filters, I thought about using the Priv Answer to the query and adding them back to the
stock table but I'm not sure what consequences will arise from doing that. I tried to post them back into the stock table but I
get the usual Key violation because they already exist.
Bottom line is the 18 part numbers are hidden from view in the stock table and inaccessible to view under normal circumstances
in the form. They can not be reloaded and can only be accessed by round about means....This is not going to cut it.
What did I do wrong to make this happen?
How can it be fixed?
I would really appreciate it if some one could help me out with this one..