#23 Loan Management

[Christopher J. Rahn]

I am very new at this, so take that into consideration.

If possible, I would like to see a few new fields added
into the base product.

1. Loaned To:
2. Loaned On:
3. Returned on:
4. Location of Movie:

The first field (loaned to) would allow a person to
type a name. Many times people will loan out their
movies to a friend, or many friends. This will allow
them to query quickly and find out who they loaned a
movie to, and on what dates. I.E. A query will need
to be run in another window that allows them to find
all movies that are loaned out that have at least one
empty row in the returned on list. (This means it
would still be loaned out).

The second field would be a date/time. It would
default to the current date time when someone clicked
the loaned to button (or added an extra field to this..
whichever you think is most user friendly).

The third field would be a date/time when the person
returned the movie (you could also have a returned on
button.. which would default to the current date/time..
and allow the user to change it).

The last field, field 4.. Would be the location of a
movie. Many times people have many movies, and to have
a varchar field (alpha-numeric) would allow the user to
specify where the movie currently resides.

P.S. I love this product. It's very well done.

Christopher J. Rahn

[Nobody/Anonymous]

Logged In: NO

hi,
you can add fields into the additional info section by
yourself and there is already a location field.

Ps. i like this product too! :-)

best regards

yves

[Matthias Ihmig]

Logged In: YES
user_id=921651
Originator: NO

Thank you for this suggestion.

Renamed request.

Matthias