Populate Child Table with Foreign key

[ExcelGirl1975]

I have three tables


tblBuildings - a table of buildings
BldgID(PK)
other fields

tblTactics - a table of building plans 'tactics' (e.g. plans to buy a building)
TacticID (PK) - an autonumber field
BldgID(FK)
other fields

tblCBAs - a table containing the costs to implement the building's tactics
CBAID (PK)
BldgID(FK)
TacticID (FK)
CBA Yr

So each year a building can have a tactic . Each tactic has a CBA associated with it.

I have related the tblTactics to tblCBA by way of tblTactics' primary key: TacticID to represent this relationship.

How do I populate tblCBA with TacticID values from tblTactics that doesn't involve knowing SQL?

(All of the other table fields have been already populated via an excel import)

Thank you!

 

[ExcelGirl1975]

Can I use an update query?

 

[ExcelGirl1975]

I just figured it out! I created an update query

 

[SydneyGeek]

If you're doing data entry, use the interface.
Base a form on the main table.
Second form on the child table; set it to Datasheet as the default
In Design view on the main form, drag and drop the subform.
IMMEDIATELY click on the Properties, go to the Data tab, and check to see that the Master and Child fields are populated. If not, put the primary key of the main form into Master, and the foreign key of the subform in the Child fields.
Now, every record you create in the subform will automatically populate the child record's foreign key.

Denis