There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
acer black screen blue screen boot computer connection crash css dell display driver drivers email error excel firefox firefox 3 game hard drive internet internet explorer itunes laptop malware monitor network networking nvidia outlook outlook 2003 outlook express partition password printer problem problems router slow software sound sprtcmd.exe startup trojan usb video virus vista windows windows xp 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!

Closed Thread
 
Thread Tools
computerman29642's Avatar
Computer Specs
Senior Member with 1,437 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
20-Jun-2008, 02:08 PM #61
I am not sure.
jimr381's Avatar
Distinguished Member with 3,622 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
20-Jun-2008, 02:10 PM #62
Can you post your latest revision of the database, so I can take a look at it? I cannot promise that I will get to it today, since I was out yesterday and everyone wants me today, but I will look at it on Monday.
computerman29642's Avatar
Computer Specs
Senior Member with 1,437 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
20-Jun-2008, 02:10 PM #63
Quote:
When you are setting up the two fields as a primary key you will want to select both of them before you click on the key icon to associate them as a primary key.
Which fields?
jimr381's Avatar
Distinguished Member with 3,622 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
20-Jun-2008, 02:15 PM #64
You are trying to alleviate duplicates in your junction table right or which table are you trying to alleviate duplicates in?
computerman29642's Avatar
Computer Specs
Senior Member with 1,437 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
20-Jun-2008, 02:20 PM #65
I am trying to stop duplication on the frmMovie form. Please take a look at the attached database. You will noticed that when the frmMovie form is opened, there is duplication.
Attached Files
File Type: zip Movie.zip (41.8 KB, 4 views)
jimr381's Avatar
Distinguished Member with 3,622 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
20-Jun-2008, 02:23 PM #66
I see nothing when I open up the frmMovie form.
jimr381's Avatar
Distinguished Member with 3,622 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
20-Jun-2008, 02:26 PM #67
Why do you have a movie number and movieID as well? Is movie number for cataloging them? It seems like replication to me. Your frmAddMovie seems to be still setup wrong. It should be a subform and not a drop-down list, so that you can see the whole list of stars.
__________________
"Take what you learn and make a difference with it."
___________________________________________

"Oh, goody!"
___________________________________________
The magic number is: 28192 for Zukirin Shikimirika****eari
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,566 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
20-Jun-2008, 02:28 PM #68
Ah now I see, the duplication comes from the Query, Not the table.
computerman29642's Avatar
Computer Specs
Senior Member with 1,437 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
20-Jun-2008, 02:31 PM #69
Are you referring to the qryStarring query? Should I be using the MovieStar query?
computerman29642's Avatar
Computer Specs
Senior Member with 1,437 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
20-Jun-2008, 02:33 PM #70
Quote:
Why do you have a movie number and movieID as well? Is movie number for cataloging them? It seems like replication to me.
Yes, the movie number is for cataloging. I have all my movies have labels with numbers written on them. So, I used the autonumber filed to index withthin the database, and the other number field to search for the movies.
computerman29642's Avatar
Computer Specs
Senior Member with 1,437 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
20-Jun-2008, 02:36 PM #71
Quote:
I see nothing when I open up the frmMovie form.
The duplication I am talking about is that of the description field, rating field, etc.

Last edited by computerman29642 : 20-Jun-2008 02:43 PM.
jimr381's Avatar
Distinguished Member with 3,622 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
20-Jun-2008, 02:38 PM #72
Are you using a different database then I am using, because I see no data within the frmMovie.
computerman29642's Avatar
Computer Specs
Senior Member with 1,437 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
20-Jun-2008, 02:42 PM #73
I am using the same one I attached. There should be three movies. Test, Test2, & Tester. Do you have any movies listed in the tblMovie table?
jimr381's Avatar
Distinguished Member with 3,622 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
20-Jun-2008, 02:44 PM #74
No I do not and do not see them in the drop-down list either. When I add my own in there I do see it with the supporting information and it is not duplicating it as well.

Did you notice that when you click on the "Add Information" button that the drop-down list at the top of the form goes away?
__________________
"Take what you learn and make a difference with it."
___________________________________________

"Oh, goody!"
___________________________________________
The magic number is: 28192 for Zukirin Shikimirika****eari
computerman29642's Avatar
Computer Specs
Senior Member with 1,437 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
20-Jun-2008, 02:47 PM #75
Are you looking at the database I attached in Thread #65?
Closed Thread

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who help people like you solve computer problems. See our Welcome Guide to get started.



Thread Tools


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 10:40 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.