Hi there.

A friend of mine runs a business that sells panoramic pictures. A number of
galleries/shops stock these pictures on a sale or return basis. My friend
requires a system that will track the items that a gallery should have in
stock together with what they have sold. i.e. each month the gallery should
provide a completed form detailing their current stock. This should then be
compared with the data stored in the database to indicate the difference
between what the gallery has in stock and what items the gallery has been
supplied with. A bill can then be produced to charge the gallery for those
items that have been sold based on that difference. Hopefully I have
described that clearly.

Can anyone suggest a suitable table setup that would allow for this scenario
please?

Regards.

Nicholas James Pitt