[AccessD] Video Rental DB

[Stuart McLachlan]

Every time I look at a "Point of Sale" system, I think of your second meaning.  It seems as 
though that is an apt description for just about all of them. :-)

I'd definitely put  a Status flag in tblDisks and update it based on the InvoiceLine. 

Have a second table for returns which also updates the disk status.

A Union of relevant fields from your Invoice/ Invoice lines and Receipts then become your 
history without needing to maintain additional links.

I'd include a "Sold" flag and record the selling price as part of thh Invoice line, not use a 
separate table for sales.   

I'd probably go with a field in Title to differentiate directly between games and videos, but 
would also have appropriate entries in Genre AND Format (Xbox/PS2 etc)   
 


On 30 Jun 2016 at 14:53, David McAfee wrote:

> Just a quick glance, that appears to be more of a software to collect
> a list of movies and / or music.
> 
> A little back story. :)
> 
> Back in February my wife (and I) bought a little retail store. In the
> back of the store was a video rental section.
> 
> We were going to shut it down, after all who rents movies at a brick
> and mortar store these days? :)
> 
> Well, we come to find out, a lot of people. We add at least 1 new
> customer per day as they find out about it.
> 
> The P.O.S. (if you can call it that) for the rental side of the store
> is an old DOS based application running on a Windows ME or 2000
> system. I think POS doesn't stand for Point of Sales, it's more like
> Piece of Sh*t :)
> 
> I could copy the flat dbase table structure thatthe software uses, but
> I'd like to design something a little better. I want to do it in
> Access first as a rapid development tool, just to show the employees
> my thought on how the software should work.
> 
> In time, I'd like to connect to the web and/or make it a mobile app or
> web based software.
>