AnsweredAssumed Answered

multiple items, multiple payments (many-to-many join?)

Question asked by kmsitall on Nov 29, 2008
Latest reply on Nov 29, 2008 by jsalzer_1


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?