Creating record in related tables 1

[Moss100]

Hello,

I have a table called properties.

This has related tables called

Rooms
And
Fittings

When I add a new record in properties I would like to create a record in each of the other tables.

What is the best way to achieve this?

Many thanks mark.

 

[dhookom]

Try use code in the after insert event of the form bound to the properties table. It might look something like:

Dim strSQL as String
strSQL = "INSERT INTO ROOMS (foreignkeyfield) Values(" & me.primarykeyfield & ")"
Currentdb.execute strSQL, dbFailOnError
strSQL = "INSERT INTO FITTINGS (foreignkeyfield) Values(" & me.primarykeyfield & ")"
Currentdb.execute strSQL, dbFailOnError

Duane
Hook'D on Access
MS Access MVP

 

[Moss100]

Thank you kindly -A1

 

[Andrzejek]

If dhookom’a post was helpful, click on: [blue]Like this post? Star it[/blue].
This indicates the post answered your question and marks it for other to see the solution.


Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.