Automatically populate field on existing db

[Jan S via AccessMonster.com]

I have an existing Customer Complaint db which has a single table with all
data fields in it. There are 2 text fields "Defect Type and Classification" .
Currently on the form the Defect Type and Classification are both Value Lists.
Currently the user can assign any Classification to a Defect Type.

Our new QA Mgr has classified each Defect Type individually. We have 57
Defect Types with each one having one of 3 Classifications (Minor, Major or
Critical). I created a new DefectType-Class table with Field 1 being the
DefectType and Field 2 being Classification. I have entered all Types with
their corresponding classes as defined by the QA Manager (a single
classification dependent upon the Defect Type).

I have a 2 part issue that I am not sure how to implement. I want to use the
new DefectType-Class table for the fields on the current form without losing
the data that has already been entered and with that change be able to
populate the Class on the form when the user chooses the defect type.

Thank you, Jan

 

[Guest]

You will want a new table for Defect Type - which will have 57 records. You
will want to have a new table for Defect Class - which will have 3 records.

These tables will serve no other purpose that to provide the selection
available to your end user.

In your modified form when someone is creating a new Customer Complaint it
surely already creates a new record number probably via autonumber. Now you
present the customer with a pull down from the Defect Type table and you
present the pull down for class.

Their selection goes into these same fields in your existing complaint table
and will not affect past entries/records.

Not really enough time for me here to explain how to modify your form but
this is an outline of the concept you will want to implement.

 

[Jan S via AccessMonster.com]

I am knowledgeable enough in Access to be able to modify the form. You are
also correct about creating a new complaint. I may not have explained myself
clearly enough. Each of the 57 Defect Types has had a preassigned Class
assigned to it. I would like for when the user pulls down the defect type to
have the classification automatically populate a field I will create next to
it.

Thank you again for you help.