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
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?