I'm currently trying to write a stock system for work. I have the basic stuff licked, but I'm trying to set up some nice, user friendly print outs using queries and reports.
A little background to start. The main task will be to book in items that have been recieved for repair. To do this, the user opens a form from the menu, which contains some basic information on the customer and the order, and a sub form, which allows the user to add items to be repaired. In the sub form is a field for Stock Code which is a drop down box with a lookup to a seperate table, which has a list of codes for all the products we repair.
At the bottom, is a button to print a job sheet. This button runs a report, which uses a query to take the Job Number from the form, and set out the details of the job in a nicely set out way, grouped by the stock code.
Now, what I want is for the report to have, next to the stock code, the description of the item. This is stored in the same table already, I just need a way to access it. Can this be done?
Sorry for the slightly long winded question, but I couldn't think of a way to word it without telling you the details
I'd be very grateful for any help
A little background to start. The main task will be to book in items that have been recieved for repair. To do this, the user opens a form from the menu, which contains some basic information on the customer and the order, and a sub form, which allows the user to add items to be repaired. In the sub form is a field for Stock Code which is a drop down box with a lookup to a seperate table, which has a list of codes for all the products we repair.
At the bottom, is a button to print a job sheet. This button runs a report, which uses a query to take the Job Number from the form, and set out the details of the job in a nicely set out way, grouped by the stock code.
Now, what I want is for the report to have, next to the stock code, the description of the item. This is stored in the same table already, I just need a way to access it. Can this be done?
Sorry for the slightly long winded question, but I couldn't think of a way to word it without telling you the details
I'd be very grateful for any help
