Help with Rental form

[cathywoodford]

Hi. I have a small movie database to keep track of friends who have
borrowed DVDs. My friends come in and open the database, search a
movie and a movie form opens to tell them if the movie is borrowed or
not. If it is, the name of the person who has it borrowed is shown.
If it isn't and they would like to borrow it, they can hit the borrow
button and then a borrow screen opens in add mode. This borrowing
window is based on the borrowed table and I pass the movie id/movie
title from the previous screen and it automatically adds a new rental.
I would like my friends to be able to select their name from the list
of friends names, if they are there, but if not they can add their name
to the database. I hope I haven't got anyone confused. This way there
will not be duplicates..

 

[MBSNewbie]

Here's a thought:

Create Another Table Named Friends, Instead of an Input Box, Use a Dropdown
on the Borrow Screen taking the list of names from the Friends table. (You
can also Link to a Form or even the table to Add A friend)