Invoice not working right

[Robbydobbs]

I have an invoice, but I believe I have it setup all wrong.

First part - Header: I have the header reading company information.

Second part - Body: Showing info from the payment screen.

Third part - Footer: I have totals and a paragraph explaining the invoice rules. In the footer, I have related fields that has 4 repeated fields that show the payment history. If I try to use a Summary part, then I loose the payment history.

The problem that I'm having is that when I do a find on the Buyer ID_NO and go to the invoice that all the records show up but they are all under the first Inventory ID_NO instead of their own individual Inventory ID_NO. I'm sure that this invoice is not done correctly, but I don't know a better way to set it up.

Could someone please explain to me a better way if they know it?

Let me explain exactly what I have that I'm trying to print out.

I have 4 main databases that I use to get my information.

1- Inventory (entry of all sale items PK Inventory:ID_NO)

2- Buyer (creation of customer ID number) Relationship clerking:BuyerID|Buyer:ID_NO

3- Payments (paying for items by customer ID number, each record is copied and pasted from the Buyer DB to the Payments DB. Relationship Payments:BuyerID|Buyers:ID_NO

4- Clerking (assigning prices to each item, each record is copied and pasted from the Inventory DB to the Clerking DB. Relationship Inventory:ID_NO|clerking:ID_NO); also clerking is related to payments. Relationship Clerking:BuyerID|Payments:BuyerID

The invoice layout is in the Clerking DB. I have created a relationship with the Clerking DB called Invoice where the BuyerID in Clerking is related to itself. All the fields in the body of the invoice is from the relationship Invoice.

I hope this all makes sense.

Now when I run the script:

Go To Layout (Invoice)

Go To Related Records (Show only related Records_Invoice)

Perform Script, external (clerking) "Print Invoice"

Refresh Screen, bring to front.

I get all the inventory for that particular buyer ID_NO which for the one I am using is 5 records, but the result shows all the same Inventory:ID_NO instead of each individual ID_NO.

What am I doing wrong?

Here is a sort of example of what it is suppose to be:

Buyer ID_NO Inventory ID_NO Qty Year Inventory Price Buyer's Fee Tax

344 | 712 | 1 |1988 |Chev Berreta |1100.00|100.00 | 79.20

344 | 784 | 1 |1993 |Mercury Sable|1200.00|100.00 | 85.80

344 | 851 | 1 |1994 |Nissan Maxima|5500.00|100.00 |369.60

344 | 852 | 1 |1992 |Ford F250 PU |3350.00|100.00 |227.70

344 | 853 | 1 |1996 |Ford Taurs |3300.00|100.00 |224.40

This is what I am getting:

Buyer ID_NO Inventory ID_NO Qty Year Inventory Price Buyer's Fee Tax

344 | 712 | 1 | 1988 | Chev Berreta |1100.00|100.00 | 79.20

344 | 712 | 1 | 1988 | Chev Berreta |1100.00|100.00 | 79.20

344 | 712 | 1 | 1988 | Chev Berreta |1100.00|100.00 | 79.20

344 | 712 | 1 | 1988 | Chev Berreta |1100.00|100.00 | 79.20

344 | 712 | 1 | 1988 | Chev Berreta |1100.00|100.00 | 79.20

Could someone try and tell what I am doing wrong?

[Chuck]

I'm afraid that I don't understand everything you've said, but as a general rule, print an invoice from the file that the line item data is in. In other words, if you want each line of the invoice to show a record from the payment file, then create the found set in the payment file and print from a layout in that file.

Chuck