auto populate mutiple fields

[jomoan58]

I need some input regarding the following:

I am trying to populate multiple fields on a form by selecting a single item from a look-up list. But it's really not a simple as this.

In my table I have a maintenance code that is tied to multiple equipment codes. Each equipment code needs to be recorded as a single piece of data. What I am trying to do is create a form where the user can select from a look-up list the maintenance code to populate the maintenance code field and then the associated equipment code fields will auto populate with only one equipment code per field.

I do not code..at all. I've included a diagram to help demonstrate what I am trying to do.



Thank You.

PS I apologize in advance for any breech of "forum protocol"

[esglover]

I did something similar in my database.

First (if you don't already have a table that has this information) I would make a Select query that pulls all of the necessary info together. Each row should contain the Maintenance code along with all of the Equipment codes that you want to update when the maintenance code is selected.

Example: (one row of data with header)

Maintenance Code Equipment Code 1 Equipment Code 2 Equipment Code 3
000000000000156 000000000000024 000000000001489 000000000002261

Then make an update query and set it to run on the After Update event for the Maintenance code lookup list. In this update query you should update Equipment Code 1, 2, 3, etc to the value in your select query where Maintenance code on your form equals the Maintenance code in your select query.