On Feb 29, 9:23*am, "myersp...@gmail.com" <myersp...@gmail.comwrote:
Hi, new to this group and new to Access.
I work for a water filtration company here in South Australia, our
customers are in MS Access.
Each day I am faxed a "Job Sheet" for the following days work with the
customers: Name: Address: Phone No.: and the Filter System they have.
Now my question:
Can the "Job Sheet" be generated by
1/ Going into the customers record
2/ Clicking on the Phone No (Its the only unique field)
* * * And the record goes onto a *"Job Sheet"
Then, the process is repeated until the "Job Sheet" is populated,
whether its with 2 jobs or 10 jobs?
Hi
You need to create a couple of tables in access. I would create a
table called something like tblCustomers with all the fields needed
for the details of the jobsheet ie Name, address, filter system name
etc- this acts as s permanent customer data table. I would set an
Autonumber field as a unique ID, and not recommend a telephone field.
Next a couple of related tables to hold the jobsheet records-
something like tblJobSheet, with an autonumber unique ID field
JobSheetID and then a field to mark the date of the jobsheet and
fields for any other relevant details. Then create another table-
tblJobSheetCustomers, which really mimics the tblCustomers fields, and
has the JobSheetID field- to be able to relate the two tables
together- 1 to many. Then basically you need to have a function on a
form that raises a new jobsheet record and selects the range of
customers to be incuded in the job- using the tblCustomers reference,
once selected the customers are copied across from the tblCustomers
into the tblJobSheetCustomers table. I would suggest doing this
through a list box control and using VBA and an add new sql statement
or call a recordset routine, or if that is a bit unfamiliar for you-
queries and macros would do it!
Good luck
David