[AccessD] Video Rental DB

[Jim Dettman]

 You might consider going along the lines of an inventory system (that's
what it really is anyway), with a single table for "movement".  In other
words, all the in's and out's of a given item.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David McAfee
Sent: Friday, July 01, 2016 12:57 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Video Rental DB

Hmmm, I didn't even think of creating a returns table.

Great idea!

Thanks,
David

On Thu, Jun 30, 2016 at 4:41 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> 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.
> >
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com