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

Title

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

Post


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?

 

Thanks!

 

Outcomes