value list help
im creating a database for a photographer to track the print that he sells. When a gallery requests a print, he creates a work order/invoice. on the WO/invoice layout he needs a dropdown value list that shows all of the prints that havent been invoiced. so a value list that shows all products wont work, because a print can only be sold once. any ideas of how to create this value list? thanks for any input.