I guess. I put this in here to help sort out the stuff. The "parts" are already there. I need it to recognize the "partnumber" as the "partid" from the "parts" table.

Maybe this be easier. Say you were selling movies. One of the things that comes with the sale of a movie is the viewer rating. The cash register sends you a report that you sold JAWS. In the report it tells you that JAWS is rated R, and it is a horror movie.

Now you want to be able to see how many "R" movies that you sell over the period. So a movie ratings table has RatingID, Rating, and Rating description.

The report tells me that I sold JAWS and it is rated R. I need to be able to move this information to a combo box so it recognizes R as it would in the combobox as RatingID 3 for example.