If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Invoice problem with extra details on line items
I have been asked to create invoices on my database, there are 3 tables to
reference, the orders_header table with the order number and customer details, the orders_detail table with the line items, descriptions, quantities etc, and the orders_comments table, which is linked to line items on the orders_detail table. The problem I am having is getting the orders_comments data up onto the report. I have a report with a subform. This subform holds the line item details. Linked to this I need to have the table with the orders_comments data, but each invoice may have 20 items, of which only one line has extra comments, but these comments in turn, may reside in 3 or more fields. What is the best way to approach this problem? I have tried unsuccessfully, as the result I keep getting is the comments repeated under every line item, not just the one they are meant to refer to. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
problem with journal subject line | chunnel | Contacts | 0 | October 28th, 2005 02:28 AM |
Problem With Inserting Items When Creating New Mail Message | Freestyler | General Discussion | 0 | May 24th, 2005 10:23 AM |
Columns 'line between' problem | Jim | Page Layout | 4 | June 10th, 2004 04:15 AM |
Excel 2000 Line Chart Problem...HELP !!!! | Tushar Mehta | Charts and Charting | 2 | May 13th, 2004 12:12 AM |
Help Microsoft? WORD11.ADM File Problem Line 818? | Dwight Hutchinson | New Users | 2 | May 3rd, 2004 08:25 PM |