R
Rob S
I am trying to redo a db that our office uses because it is cumbersome and
requires multiple entries. My mind has reached a point I'm going in circles
and I need help. We track requests for assistance from other organizations.
We also create material that we distribute, such as brochures. Right now if
you receive a phone call you have to enter the appropriate data (date, staff
member, organization, topic, comments). If you receive a request for
brochures you go to a distribution screen and again enter appropriate data
(date, staff member, organization requesting product, quantity sent). The
problem in the current system is that if you receive that request for a
brochure while on the phone handling an assistance call you have to go to
the phone log and enter data, back out and go to the distribution screen and
enter very similar data and enter it again for each individual product.
There has to be a way to create a parent form based on the phone call and
then a subform that can be used if that phone call includes a request for
information. The problem that I'm having is there are multiple fields which
need to be populated in the subform which are the same as the parent. I
know how to autopopulate one field, but not multiple fields. Can it be
done?
Not all requests for brochures are linked to a phone call requesting
assistance, so there would need to be a separate form that is a "main" form
for product distribution as well.
In the end we run a 6 month report to see how many brochures of a specific
type we send, who receives them and how many are sent. So we need to be able
to run a query on the brochures table that will calculate all brochures sent
regardless of whether entered through the phone log subform or through the
main brochure. My main goal is ease in data entry, removing the need to
enter multiple screens to get the data in.
Any thoughts? They would be greatly appreciated.
Robert
requires multiple entries. My mind has reached a point I'm going in circles
and I need help. We track requests for assistance from other organizations.
We also create material that we distribute, such as brochures. Right now if
you receive a phone call you have to enter the appropriate data (date, staff
member, organization, topic, comments). If you receive a request for
brochures you go to a distribution screen and again enter appropriate data
(date, staff member, organization requesting product, quantity sent). The
problem in the current system is that if you receive that request for a
brochure while on the phone handling an assistance call you have to go to
the phone log and enter data, back out and go to the distribution screen and
enter very similar data and enter it again for each individual product.
There has to be a way to create a parent form based on the phone call and
then a subform that can be used if that phone call includes a request for
information. The problem that I'm having is there are multiple fields which
need to be populated in the subform which are the same as the parent. I
know how to autopopulate one field, but not multiple fields. Can it be
done?
Not all requests for brochures are linked to a phone call requesting
assistance, so there would need to be a separate form that is a "main" form
for product distribution as well.
In the end we run a 6 month report to see how many brochures of a specific
type we send, who receives them and how many are sent. So we need to be able
to run a query on the brochures table that will calculate all brochures sent
regardless of whether entered through the phone log subform or through the
main brochure. My main goal is ease in data entry, removing the need to
enter multiple screens to get the data in.
Any thoughts? They would be greatly appreciated.
Robert