Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help with Rental form

Discussion in 'Information Technology' started by cathywoodford@personainternet.com, Jul 28, 2006.

Tags:
  1. cathywoodford@personainternet.com

    Guest

    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..
     
  2. Loading...


  3. MBSNewbie

    MBSNewbie
    Expand Collapse
    Guest

    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)

    <cathywoodford@personainternet.com> wrote in message
    news:1152295079.697642.240700@s16g2000cws.googlegroups.com...
    > 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..
    >
     

Share This Page