P
Perplexed
Background:
I currently designed a database with three tables
1) Customer's name, address, etc.
2) Customer's appt dates, times & whether or not cancelled and why
3) Customer suspension information
they are all linked via Customer ID with a one to many relationship.
I have a form with a combobox in the header which I can use to lookup
existing customers by address. When selected it propagates the corresponding
fields in the detail section. The customer appt and suspension tables are
shown in subforms in which daily information is entered and each table is
updated.
I then can run a report based on a query which gives me a list of customers
who have cancelled their appts and calculates a total if the reason is other
than "1" for routine.
This information is input based on a handwritten daily dispatch log.
Everything is working perfectly thanks to everyone's helpful input and ideas.
Question:
I would like to develop a form based on the dispatch log that allows the
dispatcher to input directly into the database instead of having to transpose
the handwritten form.
I need the same combobox in the header section to allow the dispatcher to
select an existing rider or enter new information into the detail section.
Problem:
This is a dispatch log/system in which when the name, address, date, time is
entered I need to see it as a list of customers to be contacted for the day
and will need to be sorted by pickup time. Once the dispatcher feeds this
info into his form I want the three tables from my previous form to be
updated so I don't have to use my first form any more.
For clarification -- this is a dial-a-ride customer dispatch system -- so if
anyone is familiar with transportation authorities this might make my
question is little more logical.
Appreciate any and all advice!
I currently designed a database with three tables
1) Customer's name, address, etc.
2) Customer's appt dates, times & whether or not cancelled and why
3) Customer suspension information
they are all linked via Customer ID with a one to many relationship.
I have a form with a combobox in the header which I can use to lookup
existing customers by address. When selected it propagates the corresponding
fields in the detail section. The customer appt and suspension tables are
shown in subforms in which daily information is entered and each table is
updated.
I then can run a report based on a query which gives me a list of customers
who have cancelled their appts and calculates a total if the reason is other
than "1" for routine.
This information is input based on a handwritten daily dispatch log.
Everything is working perfectly thanks to everyone's helpful input and ideas.
Question:
I would like to develop a form based on the dispatch log that allows the
dispatcher to input directly into the database instead of having to transpose
the handwritten form.
I need the same combobox in the header section to allow the dispatcher to
select an existing rider or enter new information into the detail section.
Problem:
This is a dispatch log/system in which when the name, address, date, time is
entered I need to see it as a list of customers to be contacted for the day
and will need to be sorted by pickup time. Once the dispatcher feeds this
info into his form I want the three tables from my previous form to be
updated so I don't have to use my first form any more.
For clarification -- this is a dial-a-ride customer dispatch system -- so if
anyone is familiar with transportation authorities this might make my
question is little more logical.
Appreciate any and all advice!