multiple items, multiple payments (many-to-many join?)
Muddled newbie asks:
A gallery sells individual works of art on consignment at an annual auction (auction table)
Consignors are in a separate Consignors address table.
Consignors are paid after the auction, so checks cover some, but not necessarily all of the works they own (payments table).
How can I specify which works are being paid for with an individual check?
How can I show when a check is only a partial payment for one work?