[AccessD] Video Rental DB

[David McAfee]

You have a point. There are other items right now that are sold and could
all be rolled into a POS / inventory system
On Jul 1, 2016 1:02 PM, "Jim Dettman" <jimdettman at verizon.net> wrote:

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