I am setting up a database of photos and fine art prints made from those photos. I have a table that lists each photo and its related data. Each photo can then have a number of prints made from it (each one can be different size, material etc.) They should each be numbered individually and sequentially and not exceed a defined edition size. Each print can then be sold to a customer, so I will also have a sales table and a customer table. My question is about the prints table. Can I have a different print table for each photograph? If so, I don't know how to link to the correct table based on which photo I am looking at. Or must I lump them all into one big print table. If I do that, I don't know how to automatically assign the sequential print number for each photograph (e.g. I could be up to print 5 of photo 1, but 10 of photo 2.) Any ideas?