Robert88
Robbie
- Local time
- Today, 21:09
- Joined
- Dec 18, 2004
- Messages
- 335
Hi All,
I have four tables that are part of a CD Labelling Database.
They are used like a list to set default values within my database and all tables are not within any relationship.
These tables and structure are;
tblLabelNumber
fldLabelNumber - Text
fldDefaultLabelnumber - Yes/No
tblLabelType
fldLabelType - Text
fldDefaultLabeltype - Yes/No
tblMediaDrive
fldDriveName - Text
fldDefaultDrive - Yes/No
tblMediaType
fldMediaType - Text
fldDefaultMediaType - Yes/No
Currently in each table only one of the "Yes/No" Data types in each table have been selected as "YES". I need these table to only have one "Yes/No" selected as "YES", as I query the database for the default one, the only one, marked "YES".
I am not that familiar with validation rules but wondering if validation rules will allow me to restrict users from selecting more than one "Yes/No" field within these tables?
If validation rules are what I should use, if you could give an example knowing that the tblLabelNumber only has six records containing 1, 2, 3, 4, 5, 6 and fldDefaultLabelnumber has been selected to Yes for record 6.
I thank anyone in advance for any advice on this one.
Robert88
I have four tables that are part of a CD Labelling Database.
They are used like a list to set default values within my database and all tables are not within any relationship.
These tables and structure are;
tblLabelNumber
fldLabelNumber - Text
fldDefaultLabelnumber - Yes/No
tblLabelType
fldLabelType - Text
fldDefaultLabeltype - Yes/No
tblMediaDrive
fldDriveName - Text
fldDefaultDrive - Yes/No
tblMediaType
fldMediaType - Text
fldDefaultMediaType - Yes/No
Currently in each table only one of the "Yes/No" Data types in each table have been selected as "YES". I need these table to only have one "Yes/No" selected as "YES", as I query the database for the default one, the only one, marked "YES".
I am not that familiar with validation rules but wondering if validation rules will allow me to restrict users from selecting more than one "Yes/No" field within these tables?
If validation rules are what I should use, if you could give an example knowing that the tblLabelNumber only has six records containing 1, 2, 3, 4, 5, 6 and fldDefaultLabelnumber has been selected to Yes for record 6.
I thank anyone in advance for any advice on this one.
Robert88
Last edited: