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
jimr381's Avatar
Distinguished Member with 3,530 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
16-Jun-2008, 01:33 PM #16
Aye I would organize it as a many to many relationship since it should feasibly be setup like I said before.
I see you have other forms. Are you planning on making a switchboard to access these or just using the database window?
gamecockfan's Avatar
Computer Specs
Senior Member with 1,197 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
16-Jun-2008, 01:37 PM #17
I have not decided on the switchboard. I have thought about creating one, but I have not made my mind up yet. What do you think?

I will change the relationship to Many-To-Many. I still have not figured out how you all were talking about setting up the frmAddMovie form to select more than one star.
__________________
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
16-Jun-2008, 01:50 PM #18
I think OBP was talking about the form. Isn't it ya'll down there instead of you all?
gamecockfan's Avatar
Computer Specs
Senior Member with 1,197 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
16-Jun-2008, 01:56 PM #19
LOL....Well, I guess that would be a true statement. Every now and then we can speak with proper grammar down here.

The correct way to setup a Many-to-Many relationship would be through a junction table...right?
jimr381's Avatar
Distinguished Member with 3,530 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
16-Jun-2008, 04:19 PM #20
Aye it would utilize a junction. I am from VA and that is supposed to be a southern state as well.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,197 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
16-Jun-2008, 04:24 PM #21
I will create the junction table and relationship(s), and then repost the db. I want to be sure it is done correctly.

LOL....Why you given me a hard time then?
gamecockfan's Avatar
Computer Specs
Senior Member with 1,197 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
16-Jun-2008, 04:28 PM #22
I have created the junction table (tblMovieStar). Please take a look at the relationship(s), and let me know if I now have a Many-To-Many relationship established.
Attached Files
File Type: zip Movie.zip (43.0 KB, 4 views)
gamecockfan's Avatar
Computer Specs
Senior Member with 1,197 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
17-Jun-2008, 02:55 PM #23
How do youknow if a Many-To-Many relationship has been established?
jimr381's Avatar
Distinguished Member with 3,530 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
17-Jun-2008, 03:34 PM #24
There is not really something called a many-to-many relationship when you examine the relationship via the window. You just know that you have two one-to-many relationships that are hitting a junction table.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,197 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
17-Jun-2008, 04:04 PM #25
When I tested the junction table by creating a new movie, no data goes into the junction table.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,197 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
17-Jun-2008, 04:10 PM #26
By chance did you happen to take a look at the attached dataabase?
jimr381's Avatar
Distinguished Member with 3,530 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
17-Jun-2008, 04:40 PM #27
The cast should be setup in a subform, so that you can select multiple cast members for the movie. This subform will reference the junction table. I would setup the fields in the junction table as a drop-down list that references the star table.

Last edited by jimr381 : 17-Jun-2008 04:51 PM.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,197 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
17-Jun-2008, 04:42 PM #28
I will work on getting that done. Thanks.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,197 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
17-Jun-2008, 04:44 PM #29
The subform would be added to the frmAddMovie form...correct?
jimr381's Avatar
Distinguished Member with 3,530 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
17-Jun-2008, 04:52 PM #30
Aye. I was still adding information to my previous post when a client asked a question, so you might want to reread it. You also are missing X as a rating for the movies as well, unless you do not loan those out.
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 02:55 AM.
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.