Form for 'Many-Side' assign 'One-Side' relationship

[Excel_Kid1081]

Hello-

I have a question on building a form to update two tables in my database which have a 1:M relation.
1) tblSecurityFamily (One)-Primary Key=SecurityFamily_ID (autonumber)
2) tblSecurities (Many)-Primary Key=Security_ID,
Foreign Key=SecurityFamily_ID

These tables will be updated from the tblNewSecurities which contain new Security_ID numbers along with some other data relevant to each row of data. However, my predicament is that I need to have the USER assign a SecurityFamilyName & SecurityFamily_ID (autonumber) to the table tblSecurityFamily first before adding the new Security_IDs and Descriptions.

How do you add the “One-Side” of a relationship when given the “Many-Side” first?

I attached a diagram of my table structure. Any thoughts are much appreciated!

Thanks!

EK

 

[DCrake]

What you need to do is to calculate the next autonumber in the parent table and pass it to the child table then add to the parent table.