I have 3 tables: Member, Video and Rentalinfo. The Rentalinfo has rel'n to member ph.# and Video# from the other 2 tables. Also, I have a rental date field added. The RENTAL form has all of this enabled. Do I create another form for RETURNING info (ie. Return date and Video#?) I'm not too sure how to set the form's to show what info so I can connect the correct and most current record from the RENTAL with the RETURN info?? Any help would be mucho appreciated!! THANKS!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
easy answer probably but i can't figure it out...
- Thread starter bbcwjun
- Start date
Hi!
What I would probably do is create another table with the same structure as the Rentalinfo table and use it to archive records after the video has been returned. You can set up an append query to daily append the records from the Rentalinfo table to the archive table and then a delete query to delete the records from the Rentalinfo table. That way, when a video is returned, there is only one record for it in the Rentalinfo table.
hth
Jeff Bridgham
bridgham@purdue.edu
What I would probably do is create another table with the same structure as the Rentalinfo table and use it to archive records after the video has been returned. You can set up an append query to daily append the records from the Rentalinfo table to the archive table and then a delete query to delete the records from the Rentalinfo table. That way, when a video is returned, there is only one record for it in the Rentalinfo table.
hth
Jeff Bridgham
bridgham@purdue.edu
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question