Parent/Child Table References in Forms

[R Tanner]

Hi,

I want to create a form to enter a record in a tickets table. I have
another table with issues that is a parent table with a lookup column
in my tickets table.


If I want to create a form to update my Tickets table and I want the
rep to select the type of issue associated with the ticket, after I
link the combo box to fields in the Issues Table, then I would want
the value to be entered into the Tickets table. This is completely
possible right? I am still sort of in the fog with Access. I'm
starting to get it, but it's coming sort of slowly...

 

[Beetle]

First, you should not be using a lookup field in your Tickets table. Lookup
fields, which are more commonly known as combo boxes, belong in
forms, not tables. For further discussion on the issue see;

http://www.mvps.org/access/lookupfields.htm

As to your form, you would typically create a main form based on the
issues table with a subform based on the Tickets table. The Master/Child
link of the form/subform will automatically handle inserting the appropriate
foreign key value in the Tickets table based on the issue that is selected
in the main form.