Relationships, forms and combo boxes

[J. Hai]

Okay, this is my first attempt at creating forms in MS Access. I've finished setting up a relational database, part of which includes a table for a video library and another table for categories (see attachment for the whole relationships window).

I've started a data entry form for the Library table and want to make a combo box for the Category field that pulls entries from the Categories table.

However, the way the one-to-many relationship is set up between the two tables, the Category field in the Library table is set to the Number data type, to correspond with the AutoNumber CategoryID primary key in the Categories Table. But I don't want a list of numbers to appear in the drop-down combo box, I want the names of the categories. How do I make this happen?

 

[pbaldy]

If you use the combo box wizard, it will build it for you. Basically it will return both columns but hide the numeric value.

 

[J. Hai]

Thanks for your prompt and helpful replies!

The next thing I have to make now is a "Production Credits" section of the form. Here I want to have a series of combo box pairs - the boxes on the left contain the RoleNames (Producer, Director, Editor, etc.) from the Roles table and the boxes on the right contain the first and last names from the Members table.

How do I link the combo box pairs together so that they populate the Student_Role_Catalog junction table with each entry? Or is there a better way to approach this?