A
anonymous
Hi all.
I am creating a database that is very similar to the sample database,
northwind.
Obviously, some of the features in my database are different, and one of
those features is the ability to fax our order (order detail) to our
suppliers. We are a small company (no warehouse) so we only order to our
suppliers when our clients order products from us. So here is what I am
trying to do:
List all of the Order Detail records and I can select any record and when I
click a button it prints out selected Order Details. When printing orders,
the report should be grouped by suppliers. (So a set of orders are printed
for one supplier at a time)
Here's how I implemented it:
Create a form that lists all of the Order Detail records (tabular format).
Add a check box for each record so I can select any record to print out
Put the above mentioned form inside a form that has a PrintOrder button.
When PrintOrder button is clicked, it prints out selected order details by
each supplier.
Here's my problem:
When I check the check box (which is unbounded), every record in the subform
is checked together. I know why it happens, and I know if I create a yes/no
type field in my order detail table, I can make this work but creating a
field for each record just so I can use it in a form seems ...... well,
wasteful.
I also thought about creating combo boxes with product id/order id combined,
but it would look ridiculous, I think.
So any suggestion to improve my project would be greatly appreciated.
Thank you for reading this long long question.
I am creating a database that is very similar to the sample database,
northwind.
Obviously, some of the features in my database are different, and one of
those features is the ability to fax our order (order detail) to our
suppliers. We are a small company (no warehouse) so we only order to our
suppliers when our clients order products from us. So here is what I am
trying to do:
List all of the Order Detail records and I can select any record and when I
click a button it prints out selected Order Details. When printing orders,
the report should be grouped by suppliers. (So a set of orders are printed
for one supplier at a time)
Here's how I implemented it:
Create a form that lists all of the Order Detail records (tabular format).
Add a check box for each record so I can select any record to print out
Put the above mentioned form inside a form that has a PrintOrder button.
When PrintOrder button is clicked, it prints out selected order details by
each supplier.
Here's my problem:
When I check the check box (which is unbounded), every record in the subform
is checked together. I know why it happens, and I know if I create a yes/no
type field in my order detail table, I can make this work but creating a
field for each record just so I can use it in a form seems ...... well,
wasteful.
I also thought about creating combo boxes with product id/order id combined,
but it would look ridiculous, I think.
So any suggestion to improve my project would be greatly appreciated.
Thank you for reading this long long question.