Hello everyone,
The database i'm creating is for my sent and received quotations sent (me being the middle man).
I created all the tables and forms I need for this, I would like to add an append query that would let me add a single entry from the "Quotation Requests Received" table to the "jobs" table, the append query would add all the table to the other, while i want it to add a single entry.
I understand it should be a button with an on click event procedure.
Bottom line, i want a a query that would let me add a single entry from one table to another
The database i'm creating is for my sent and received quotations sent (me being the middle man).
I created all the tables and forms I need for this, I would like to add an append query that would let me add a single entry from the "Quotation Requests Received" table to the "jobs" table, the append query would add all the table to the other, while i want it to add a single entry.
I understand it should be a button with an on click event procedure.
Bottom line, i want a a query that would let me add a single entry from one table to another