Checkbox to pick record & put into another table

Hi arkswt,
If I understand what you are saying correctly, your are selecting items that you DON'T want to order, even if the computer is suggesting them.  Wouldn't it be easiest to make your purchase list out of a query of the table where the items are not checked?  If this changes each time you make an order, you could assign a macro to remove all of your checkmarks from the table when you order the items not checked into stock (or when you recieve them, the point is it would reset the computer reccomendations if you wish.)
The underlying rule is that data should not be stored anywhere twice if you can help it.  Different queries or "views" of the data may be a smarter way to approach this problem.

hi CiceroBC
 thanks for ur reply. may be i did'nt made myself clear. actually the only reason i am showing the full list of everything which is low is because my cliet wishes to have a look what is below the level & then to choose which one's they wanna order out of that list.
i dont hav eany checkboxes in the table. my query is returning the results where the current stock level is below the limit set by the management for that product. my approach of using checkboxes is just to select items from that view.
my client do want to c what ever is below the level but does'nt wants to order everything out of that.

secondly i am not storing data twice the only reason i want to put the selected items into a diff able is to keep a record of all purchases which ofcourse will be deleted after a certain period of time.

Thanks

hi
thanks for ur help guys. now also help me deciding how to give the points.

all three replies actually helped me & gave me a better view of the problem. all of u basically said the same thing but i found CiceroBC's idea more helpful eventually, of having yes/no in the same table instead of creating a temp table.

i am not really sure how to assign points so help me:)

Thanks once again

Hello,

To put the yes/no field in the main table is easier. However, only one user can use the mechanism at any one point. If your need several users to select products, you will need a temporary table for each one.

> i am not really sure how to assign points so help me:)

To close this question, you would typically either select the most useful answer (use the accept button) or split points among those that helped you (use the "Split" link above the comment box).
If the solution evolved through many posts by various experts, you should always use "Split", but that is not the case here.
As for the actual points distribution, that's entirely up to you, of course.
See also: {http/help.jsp#hs5}, or the Help link at the top right of the page.

Cheers!
(°v°)

Thanks for the points and grade!

Good luck with your project!
(°v°)