Adding Records in a Subform

[chris.williams]

I have a primary form which contains the Pk for table "tickets"



On that form, I need to create subform which displays multiple records from the "images" table.

The relationship between the tables is 1-M, Tickets-Images.

How do I go about creating a subform which would allow me to associate all new records to the ticketID field? Additionally, all fields in the subform for Images would be dropdown selections based on relationships from other tables.

The sample Assets db for Access 2010 has the functionality I need in the Asset List and Contact List forms, but I am not understanding the details of it.

Thanks...

[Toyman]

I have a primary form which contains the Pk for table "tickets"

On that form, I need to create subform which displays multiple records from the "images" table.

The relationship between the tables is 1-M, Tickets-Images.

How do I go about creating a subform which would allow me to associate all new records to the ticketID field? Additionally, all fields in the subform for Images would be dropdown selections based on relationships from other tables.

The sample Assets db for Access 2010 has the functionality I need in the Asset List and Contact List forms, but I am not understanding the details of it.

Thanks...

Since your "TicketID" is the primary key for the table, "ticket", you will need a foreign key field in the Image table to receive the "TicketID". This two fields should be your relationship between the tables to create a one to many relationship: one TicketID from your Ticket Table to many Foreign-TicketID in the image table. You then create a sub form based on the image table and link the "parent/child" relation between the main form to the subform via the TicketId/Foreign-TicketId fields

[chris.williams]

Thanks - but I have already created the FK - I just forgot to mention it. What I am referring to is how do I go about adding records in the sub-table, it only displays them.

[Toyman]

Thanks - but I have already created the FK - I just forgot to mention it. What I am referring to is how do I go about adding records in the sub-table, it only displays them.

You can change the property of the sub form to allow edits, deletions, and additions. If you can allow records to directly enter into the subform, the foreign key will automatically take on the primary key value because the parent/child link you have. Another way would be using an entry form. To have the foreigh key set to the primary key, you can set the default value of the entry form's foreign key to that of the main form's primary key