Probably Simple but not for me :( Link some info like.. 1

[bbcwjun]

I have 3 tables: Memberinfo, Videoinfo, Rentalinfo. The Rentalinfo table links/looks up Member Ph. #, and Video # and I've also added a Rental Date. My question is, how and where would I put a RETURN DATE and VIDEO # in a form/table to match the RETURN with the RENTAL record as there may be multiple records with the same video #??? I can't see the logic somehow?? THANKS for any help!!

 

[jflachman]

Let me make sure I understand your question...
You have 3 tables:
Member Info
[tt]MName
Address
Phone, etc[/tt]

Video Info
[tt]VName
Video #, etc[/tt]

Rental Info
[tt]Phone
Video #
Rental Date[/tt]

You want to record the Return Date somewhere in your database.

Why not add that field to the Rental Info table? That way it is definitely linked to the rental date. When someone returns a video, you need to search the Rental Info table for the [tt]Video #[/tt] with the most recent [tt]Rental Date[/tt]. Put the return in that record.


If there is some reason you don't want to put it in that table, then you'll need to add a [tt]Rental ID[/tt] field to the Rental Info table. Then make a Rental Return table that has at least two fields, [tt]Rental ID[/tt] and [tt]Return Date[/tt].

Let me know if that doesn't answer your questions. Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt

 

[bbcwjun]

Thanks for your suggestion. It worked but now I am having a problem with the first form, when I enter a Video #, how and where can I have it check to see whether they have seen the same Video # before? THANKS!

 

[bbcwjun]

Thanks for the info! It worked but now I am wondering how and where can I check to see if the person has seen the same Video# before??

 

[jflachman]

You just need to query the Rental Info table for the [tt]Phone[/tt] and [tt]Video #[/tt] fields. If any records show up in that query, that video has been rented by that account.

I have to say, why do you care if they want to rent the same video twice? Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt