Use forms to append table

T

Tom Brown

I have three forms. frm_Login, frm_FS_Driver, and frm_Trade_Driver. A
cashier logs in using frm_Login, which contains several identifying entries
using textboxes, then uses either frm_FS_Driver or frm_Trade_Driver to enter
the days receipts for each driver that comes to her window. The driver can
be either FS or Trade, not both. I want to create append queries for each
type of driver so that the combined entries from the frm_Login and either
the frm_FS_Driver or frm_Trade_Driver create 1 record in my tbl_Master_Data.
I don't want to create one form with a login for each driver because that
would mean the cashier would potentially have to login and logout each time
a driver comes to her window. Any suggestions would be greatly appreciated.

Thanks,

Tom Brown
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to append 1 table into 2 1
Bulk Create Records and Append to Table 10
Hyperlink forms directly to a desktop 1
Multi-Search results into One Table 2
Table relationships, queries, forms and reports... 2
Append/Update Query to add multiple records to Table? 1
A question about forms... 3
signature appearing at top of custom forms 0

Top