G
Guest
Good day,
Have a question regarding a request made of me that goes a little
beyond my Access ability. I've made a fairly basic database for one of our
depts. to record information for each job they perform. The database "Job
Log" currently has just one table, "Job Information Sheet."
One function they'd like to have is: for each job, they have a list of
documents that are to be sent to the client. This is a fixed list, with a
specific amount of items (ie. invoice, certificate, etc.) However, each job
can have any combination of items to be sent. They would "simply" like to be
able to select those items to be sent for that specific job, and sometime
after selecting them, be able to enter the date on which the item was sent.
Not only would they like to use a form to enter this information, but also be
able to include upon the report for each job entry, the list of specific
items to be sent, along with their dates.
I realize a very crude way about this would be to simply enter the
list into the current table "Job Information Sheet" as individual fields
using checkboxes. Then, I could simply have individual "date" fields for the
whole list, and hope that the users would only enter data into those fields
that are selected. However, this seems very crude and cumbersome. I'm sure
one of you has a much more elegant way to go about this. Any ideas?
Have a question regarding a request made of me that goes a little
beyond my Access ability. I've made a fairly basic database for one of our
depts. to record information for each job they perform. The database "Job
Log" currently has just one table, "Job Information Sheet."
One function they'd like to have is: for each job, they have a list of
documents that are to be sent to the client. This is a fixed list, with a
specific amount of items (ie. invoice, certificate, etc.) However, each job
can have any combination of items to be sent. They would "simply" like to be
able to select those items to be sent for that specific job, and sometime
after selecting them, be able to enter the date on which the item was sent.
Not only would they like to use a form to enter this information, but also be
able to include upon the report for each job entry, the list of specific
items to be sent, along with their dates.
I realize a very crude way about this would be to simply enter the
list into the current table "Job Information Sheet" as individual fields
using checkboxes. Then, I could simply have individual "date" fields for the
whole list, and hope that the users would only enter data into those fields
that are selected. However, this seems very crude and cumbersome. I'm sure
one of you has a much more elegant way to go about this. Any ideas?