There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: Movie Database


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
gamecockfan's Avatar
Computer Specs
Senior Member with 1,207 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
30-Jun-2008, 12:23 PM #121
Quote:
You will have a junction table to link the two.
Would I need just one junction table that connects all three tables (Movie Table, Customer Table, Checkout Table), or a junction table only to connect the Customer Table and Checkout Table?
jimr381's Avatar
Distinguished Member with 3,530 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
30-Jun-2008, 02:52 PM #122
The junction table will be the checkout table. It will hold the primary keys for the Customer and the Movie table along with the checkout/checkin date.
AcaCandy's Avatar
Computer Specs
Administrator with 98,732 posts.
 
Join Date: Jan 2001
Location: Las Vegas, NV & Acapulco, Mexico
Experience: Advanced
30-Jun-2008, 02:57 PM #123
After you guys get this all set up, can you email me a copy?
jimr381's Avatar
Distinguished Member with 3,530 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
30-Jun-2008, 03:36 PM #124
Quote:
Originally Posted by AcaCandy View Post
After you guys get this all set up, can you email me a copy?

It will cost you.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,207 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
30-Jun-2008, 03:36 PM #125
Quote:
Originally Posted by jimr381 View Post
The junction table will be the checkout table. It will hold the primary keys for the Customer and the Movie table along with the checkout/checkin date.
That makes sense. I have the junction table setup as you described. Thanks.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,207 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
30-Jun-2008, 03:37 PM #126
Quote:
Originally Posted by AcaCandy View Post
After you guys get this all set up, can you email me a copy?
It will cost you big.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,207 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
30-Jun-2008, 03:39 PM #127
In your opinion, how would you do the Checkout form? Would you place another tab on the main form where the user can select a customer, and the checked out items display in a subform or just place a form on a second tab that shows all records?
jimr381's Avatar
Distinguished Member with 3,530 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
30-Jun-2008, 03:45 PM #128
I would probably do a subform within another tab or at the bottom of the main form.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,207 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
30-Jun-2008, 03:55 PM #129
I was kind of thinking another tab as well.
AcaCandy's Avatar
Computer Specs
Administrator with 98,732 posts.
 
Join Date: Jan 2001
Location: Las Vegas, NV & Acapulco, Mexico
Experience: Advanced
30-Jun-2008, 04:59 PM #130
That would be my tab Put it on my tab
gamecockfan's Avatar
Computer Specs
Senior Member with 1,207 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
01-Jul-2008, 08:21 AM #131
Quote:
Originally Posted by AcaCandy View Post
That would be my tab Put it on my tab
LOL....You got it!
gamecockfan's Avatar
Computer Specs
Senior Member with 1,207 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
01-Jul-2008, 09:50 AM #132
I am not sure of the best way to create the new tab.

I was planning to make the cboTitle combobox visible property set to false, and then have a cboCustomer combobox that will have a visible property set to true. However, the main form is tied to the qryMovie query.

Would this be a good path to continue down?

Please review the attached database.
Attached Files
File Type: zip Movie_Updated.zip (68.7 KB, 1 views)
__________________
GamecockFan

“Give, and it shall be given to you. For whatever measure
you deal out to others, it will be dealt to you in return.”
(Luke 6:38)
___________________________________________________

"Imagination is more important than knowledge. Knowledge
is limited. Imagination encircles the world." (Albert Einstein)
gamecockfan's Avatar
Computer Specs
Senior Member with 1,207 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
01-Jul-2008, 01:08 PM #133
I was thinking that using the existing cboTitle dropdown box on the main form would be better than trying to hide one and make another visible. What do you think?

However, I cannot get the cboTitle dropdown box to work for both tabs, When I select a title from the dropdown box, the form keeps jumping to the first tab.Also, the dropdown box is not populated with the first selection when the form is first opened.
__________________
GamecockFan

“Give, and it shall be given to you. For whatever measure
you deal out to others, it will be dealt to you in return.”
(Luke 6:38)
___________________________________________________

"Imagination is more important than knowledge. Knowledge
is limited. Imagination encircles the world." (Albert Einstein)
jimr381's Avatar
Distinguished Member with 3,530 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
01-Jul-2008, 04:52 PM #134
The drop-down will be fine for selecting. You would want to check and see if you could actually add records to the sub-form or see if would be setup as read-only since it is piggybacking off of a query.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,207 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
07-Jul-2008, 09:29 AM #135
Would it be better to create a separate query?
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 12:37 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.