Hi Jersey,
You probably don't need another table. Just create
a new query to select the informatioon you want.
If you want the result displayed on a form then
use the query as the source for the new form.
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "jerseydiver62" <jerseydiver62@...> wrote:
>
> Hi,
>
> I have a simple item database used to do a year-end inventory and pricing. There is a form I use to update the items with current price and last po# and date. I would like to take information from this for and add it to a different table to keep track of purchase history. The new table has the fields: AUTOID, ITEMID, COSTREF, COSTDATE, and COST.
>
> I would like to add a control button on the form to add the data from the form txtBoxes (txtITEMID, txtCOSTREF, txtCOSTDATE, txtCOST) to tblCostHistory, but I'm not sure how to code it. Also, the AUTOID in the table is an AutoNumber field to make sure there is no possibility of EXACT records. If I create a new record through the code in the form, will the AUTOID field still advance?
>
> Any thoughts or suggestions would be greatly appreciated.
>
> Thank you,
> JerseyDiver62
>
Tidak ada komentar:
Posting Komentar