I think I am learning something.
Part of my business rents videos, DJ equipment and some musical instruments.
I have a customer file and an inventory file. (not linked at this time)
I want to have a rental agreement file that will get the customer info from the customer file (easy enough I think), and list all of the items rented for the transaction, a sub total, tax and total. (still not to tough).
Here is where I loose it. The transaction can have one up to an unknown number of items rented. Also the inventory file has to be updated to show if the item is rented or returned and the customer who has the item out.
Thank you all.
Alan G