D
dknuth
I have a small database (3 tables with a total of < 12 fields). It
will be used to identify users and owners of custom reports. There are
40 reports in a folder and roughly 50 people. Each report will have
one or more owner and each report will have one or more user.
The table structure looks like this:
Reports
ReportID
ReportName
ReportDescription
Users
UserID
UserLastName
UserFirstName
UserDepartment
Distribution
DistID
ReportID
Owner
User
I wish to design a form that allows a person to:
1 - pick his name from a list.
2 - view the list of 40 reports and check the "User" box or and/or
the"Owner" box next to each report he uses or owns.
3 - click on a Save button. The Save button will create a record in
the Distribution table for each report that the person checked.
Therefore, if a person uses 5 reports and owns 2 reports, 7 records
will be appended to the Distribution table.
I am at a loss as to how to make this happen. Can anyone help?
Thank you.
will be used to identify users and owners of custom reports. There are
40 reports in a folder and roughly 50 people. Each report will have
one or more owner and each report will have one or more user.
The table structure looks like this:
Reports
ReportID
ReportName
ReportDescription
Users
UserID
UserLastName
UserFirstName
UserDepartment
Distribution
DistID
ReportID
Owner
User
I wish to design a form that allows a person to:
1 - pick his name from a list.
2 - view the list of 40 reports and check the "User" box or and/or
the"Owner" box next to each report he uses or owns.
3 - click on a Save button. The Save button will create a record in
the Distribution table for each report that the person checked.
Therefore, if a person uses 5 reports and owns 2 reports, 7 records
will be appended to the Distribution table.
I am at a loss as to how to make this happen. Can anyone help?
Thank you.