Hi,

I am very green in using Access.

I would like to update a table using a form. The form will use two tables. One of the tables is empty (table called issues) and the other has data (table called contacts).

Contacts
---------


ID
Fname
Lname
E-mail
Position
Site
Code
Hier level
CC (Primary key)

This table has 73 records already.

Issues table
------------
ID
Title
Assigned to
Opened by
Opened date
Status
Category
Priority
Comment
Due Date
Card (fk)

The issues table is empty. I would like to use a form to enter data into the Issues table. CC (PK-contacts table, no dups) and Card (FK-issues table, dups allowed) would be the fields i would join.

When a new issue would be entered in the form, i'd like to have a combo box where available cards (card field - fk) would be selected by user. I'd rather they not enter numbers by hand. I would like each record entered by the form to be stored in the Issue table.

Is it possible to do this?