Gurus,
i have a question about using check to select records from a form to create records in another table. There is no need for those check boxes in any of the existing tables, the main purpose of those it to specify which items need to be moved.
Use case is the following:
tbl_items contains all items sold by a store
tbl_RFQitems contacts items to be sent for quote to a supplier
frm_Itemview displays items based on specific search results
Each record in frm_itemview is to have a checkbox, which can be selected/unselected per record
Clicking a button moves specific values from checked records into tbl_RFQitems table
Any recommendations on how this could be done?
Thank you much in advance!