There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
acer black screen boot bsod computer connection crash css dell drive driver drivers email error ethernet excel explorer firefox firefox 3 game hard drive internet internet explorer itunes laptop lcd linux malware monitor network networking outlook outlook 2003 outlook express printer problem problems ram router slow sound sprtcmd.exe startup trojan usb virus vista windows windows xp wireless
Software Development
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Software Development >
access 2000


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
Jason3's Avatar
Junior Member with 3 posts.
 
Join Date: Oct 2006
Experience: Intermediate
25-Oct-2006, 10:17 AM #1
access 2000
I am trying to set up a database (beginner) and I do not want any fields to acept any duplicates. For e.g tracking serial numbers of similar model of say a vcr

account No serial number of vcr 1 ...serial number of vcr 1
1 2 3
2 3 2


It will not accept same serial number in one field but i don't want the d.base to accept an existing serial number which is already in a diff field. I don't want to use the p.key 'cause on one account there could be one vcr only. Any suggestions how to solve the problem

Thank u

Last edited by Jason3 : 25-Oct-2006 10:34 AM.
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
25-Oct-2006, 02:15 PM #2
Why would you have more than one Serial Number field?
Use just oe field and set it to Indexed "With No Duplicates".
Jason3's Avatar
Junior Member with 3 posts.
 
Join Date: Oct 2006
Experience: Intermediate
25-Oct-2006, 02:27 PM #3
access 2000
Thanks for the reply.

The reason there a re two serial numbers is that one customer can keep a maximum of two VCR on his acct. IF I USE one field then I'll have to enter the account number each time at every row . So if I want to display the whole thing on a form - I'll see only the first serial number . I s there a way to show all of them ?

Last edited by Jason3 : 25-Oct-2006 03:02 PM.
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
25-Oct-2006, 06:01 PM #4
The Account Number should be on a Combo Box on a main form and the serial numbers should be on a subform.
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 07:08 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.