A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

limiting data and validations



 
 
Thread Tools Display Modes
  #1  
Old February 4th, 2005, 01:57 AM
michelelenc
external usenet poster
 
Posts: n/a
Default limiting data and validations

I am trying to design a database for an engineering group. I need to limit
or restrict the type of data that goes into a field to 3 choices. I would
also like to have the same number appear in another field in all records and
if that isn't enough, I would like to be able to create a specific auto
numbering system to our unique specifications. Can you help me?
--
michelelenc
  #2  
Old February 4th, 2005, 02:17 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

Limiting a value that can go into a field in one table can be done by
creating a lookup table with the 3 values and setting up referential
integrity. Use a combo box on a form to allow selection of one of the three
values into the field.

I have no idea what you mean by the remainder of your question.

--
Duane Hookom
MS Access MVP
--

"michelelenc" wrote in message
...
I am trying to design a database for an engineering group. I need to limit
or restrict the type of data that goes into a field to 3 choices. I would
also like to have the same number appear in another field in all records
and
if that isn't enough, I would like to be able to create a specific auto
numbering system to our unique specifications. Can you help me?
--
michelelenc



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to filter and have data dropdowns via validations? ihaveadeadline General Discussion 1 October 26th, 2004 10:09 PM
copy data validations from 2000 to 2003 A0 General Discussion 6 July 22nd, 2004 05:34 AM
VLOOKUP & Data Validations Tool errors Frank Kabel Worksheet Functions 1 May 28th, 2004 03:54 PM
If/ Then with Validations? Heyna Worksheet Functions 2 April 26th, 2004 06:45 PM


All times are GMT +1. The time now is 10:30 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.