Originally Posted by
Gicu
To replace MVF you don't need multiple fields as that would go against good relational dataabase design\normalization rules. What you want is a new join or linking table.
For example you can replace all those Yes\No fields you have in tblLABnames with a new table called tblLABcertification with these fields:
LABCertID (autonumber, PK)
LABidFK (Number long, FK for tblLABid)
CertificationTypeFK (Number long, FK for new table tblCertificationType)
Now create a lookup table for the certification types (tblCertificationTypes)
CetificationTypeID (autonumber, PK)
CertificationType (Short Text)
In your forms use a combo bound to CertificationTypeFK with its row source based on tblCertificationType to display the certification type descrption but store the actual ID.
Cheers,