T
tcb
I would like to have a rule at the table level or set primary keys that
would allow only one preferred phone number and one preferred email
address.
Persons are in a parent table: tbl_Person.
Phone numbers and emails are in the child table tch_Phone_Email as
below:
PE_EMPLID PE_PorE PE_Type_k PE_Phone_Email PE_PreferredYN
0282634 P Cell 555-555-555 0
0282634 E Email1 McGilliguddy@somewhere 0
0282634 E WEmail McGilliguddy@elsewhere -1
0282634 P Work 444-444-4444 0
0282634 P Current 222-222-2222 0
0282634 P Home 333-333-333 -1
would allow only one preferred phone number and one preferred email
address.
Persons are in a parent table: tbl_Person.
Phone numbers and emails are in the child table tch_Phone_Email as
below:
PE_EMPLID PE_PorE PE_Type_k PE_Phone_Email PE_PreferredYN
0282634 P Cell 555-555-555 0
0282634 E Email1 McGilliguddy@somewhere 0
0282634 E WEmail McGilliguddy@elsewhere -1
0282634 P Work 444-444-4444 0
0282634 P Current 222-222-2222 0
0282634 P Home 333-333-333 -1