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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |