I have to make a report in Access 2000 format using Access 2003
(linked tables w/ SQL 2000) - for our Parts Inventory.
I am looking to report on the Shipping history and the Ordering
history for a specified part. Parts are linked to customers.
The user requirements are this: I am to create a form that allows the
user to choose from a list of parts and then submit the list of parts
to be reported on. I've got this far: I've made a form that has a
combo box that lets you pick the customer and it populates a listbox
control with the parts that are in stock for the selected customer.
You can control-click on the listbox and it populates a hidden text
control with a comma delimited list of the part numbers. I can pass
the list of parts and the customer ID to my report form.
Now for the report part, I'm a little stuck. I think it should work
like this (starting from the bottom most sub report and working my way
upward) - and I'm looking for input on better ways to do this, or
confirmation that this is infact, the prefered way to do this.
I think I need two "sub-sub" reports: one for Parts Ordered, and one
for Parts Shipped. Each sub-sub will take one part number and one
customer ID.
Then I'm thinking I'll add those two reports to a sub report called
Part. The Part report will also take one part number and one customer
ID. I'll have master-child link between the Part report and the two
sub-sub reports.
Finally, at the top, I'll have my Part Inventory report. This will
have the sub report called "Part" on it with the two sub-subs. It will
have the list-of-parts and the customer ID.
Does this make sense and I am I approaching this the right way?
|
Similar Threads
