Default Values in tables using validation rules..........

[Robert88]

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