Accessosaurusrex
Registered User.
- Local time
- Today, 03:18
- Joined
- Oct 18, 2010
- Messages
- 28
I will attempt to describe this well but may struggle a bit.
I have a table for a 2003 Access dbase that originally had 7 fields. I have added an 8th field for easier categorization. Let’s call field 1 job and field 2 dept and field 8 actions.
I have built a query to have the user input a job number and then display only unique records based on the dept field from the user’s job number input. There may be dozens or hundreds of records under this job but it only displays 5 due to there being only 5 departments involved.
This data is displayed in a tabular form showing the records. I now want to assign a value to the new field 8 of each record using a combo box which receives it’s selections from another table in the database. Each record may have a different “action’ value based on the department.
I then wish to perform an update query to go to all records under the selected job and apply the combo box input to each record with the same department value.
For example if I am showing the form with 5 records for 5 separate departments, I want to assign an action of “groundwork” to department 1 with “sales” to department 2 and “maintenance” to dept 3 etc. The end result would be the database going back to anything under job #1234 and with a department value of 2 putting sales to field 8 (or actions).
Thank you for your time.
I have a table for a 2003 Access dbase that originally had 7 fields. I have added an 8th field for easier categorization. Let’s call field 1 job and field 2 dept and field 8 actions.
I have built a query to have the user input a job number and then display only unique records based on the dept field from the user’s job number input. There may be dozens or hundreds of records under this job but it only displays 5 due to there being only 5 departments involved.
This data is displayed in a tabular form showing the records. I now want to assign a value to the new field 8 of each record using a combo box which receives it’s selections from another table in the database. Each record may have a different “action’ value based on the department.
I then wish to perform an update query to go to all records under the selected job and apply the combo box input to each record with the same department value.
For example if I am showing the form with 5 records for 5 separate departments, I want to assign an action of “groundwork” to department 1 with “sales” to department 2 and “maintenance” to dept 3 etc. The end result would be the database going back to anything under job #1234 and with a department value of 2 putting sales to field 8 (or actions).
Thank you for your time.
