I have 2 databases that are related to each other:

1-Payments

2-Clerking;

payments and clerking are related together by the buyer ID no.

payments:Buyer_id|Clerking:Buyer_id

In the payments database I have a portal showing 5 databases from clerking:

1-buyer_id

2-Item_id

3-Qty

4-description

5-price

If the buyer purchased a vehicle ( [color:"red"] 1st transaction ) and put a down payment of $300 and an invoice was printed, once this invoice is printed I need to flag this invoice as printed and close it. But have the option to reprint it again if I want to:[message: This invoice has been printed do you want to print it again? yes or no] If yes is selected it would then reopen the invoice and allow modification to the invoice. If the same buyer came back again and purchased another vehicle ( [color:"blue"] 2nd transaction ) and had the same buyer_id, I would want a separate invoice created for just that purchase due to the fact that the previous transaction has been closed (even if he still owes money on the 1st transaction). For Example:

Buyer_id: Item_id: Qty: Description: Price:

305 | 1458 | 1 | vehicle | 5000.00 (1st purchase) paid 300.00

new invoice - printed invoice - close out transaction -

305 | 2548 | 1 | vehicle | 3000.00 (2nd purchase)

new invoice - printed invoice - close out transaction

Buyer returns:

305 1458: Invoice has been printed. would you like to print it again.

yes or no. Yes reopen the transaction and reprint the invoice then close the transaction again.

If the buyer purchased a vehicle ( [color:"red"] 1st transaction ) and then purchased another vehicle ( [color:"blue"] 2nd transaction ) and had the same buyer_id, I would want both transactions on the same invoice as long as neither invoice has been printed. For Example:

Buyer_id: Item_id: Qty: Description: Price:

305 | 1458 | 1 | vehicle | 5000.00 (1st purchase)

305 | 2548 | 1 | vehicle | 3000.00 (2nd purchase)

new invoice - both transaction on the same invoice.

I hope I explained it well enough.

Is this possible to do?

Hello Dobber,

I'm confused you do not mention any Line Item here (different from Item I think, that is your Product File).

All this job can be done with this file.

You've got a classic many to many relationship here, so you need this File to create all this bunch.

The files you need are

1. Item (Product)

2. Invoice

3. Line Item

4. Payments

5. Payments Line Item

6. Customer

Prices and description are set in your Product File

Quantity is set in the Line Item. Eventually, discounted price could be done into the Line Item.

Do you understand the process or do you need some more here...?

obviously I have this setup wrong. I am going to re-do my payments database. I will break it down by line items instead of using portals for the information and repeating fields for the payments. I appreciate any help or advice along the way.

Thanks