Creating a record to another table automatically whenever a record is created

[gunitinug]

My question concerns two tables, jobreport_tbl and stock_tbl:

jobreport_tbl:
groupID (Autonumber)


jobdate
client
technician
...

stock_tbl:
stockID (Autonumber)
stockGroup
productRef
qty



Now, every time I enter a record in jobreport_tbl, I want to create a record in stock_tbl with stockGroup equaling groupID.

I am trying to do this using table macros. I'm thinking the one I want is After Insert macro, createRecord and then setfield macro, but so far it doesn't work as I intended.

THX

[ranman256]

make a parent/child form.
job report table as the parent,
the subform connected to stock_tbl.
join them on the like fields.

then when you save JobReport, you can enter a StockTbl entry and they will both get the same ID.
or
you can make a macro to add a random item upon parent save.

[gunitinug]

make a parent/child form.
job report table as the parent,
the subform connected to stock_tbl.
join them on the like fields.

then when you save JobReport, you can enter a StockTbl entry and they will both get the same ID.
or
you can make a macro to add a random item upon parent save.

THX but I want stock_tbl to have multiple occurrence of stockGroup. ie. can have more than one entry with the same stockGroup.

[gunitinug]

I tried:

jobreport_tbl : After Insert :
Create a record in stock_tbl
   Set field
      Name stock_tbl.stockGroup
      Value = [jobreport_tbl].[groupID]

[kd2017]

The answer ranman256 provided does allow for multiple occurrences of stockGroup per jobreport. If you switch your child form format options Allow Datasheet View->Yes and Default View->Datasheet it might make it more obvious.

That said, I mocked up the tables from post #1 and your macro code from post #4 and it works for me. Maybe you have a required field in the stock_tbl that you've forgot to set as well?

[gunitinug]

The answer ranman256 provided does allow for multiple occurrences of stockGroup per jobreport. If you switch your child form format options Allow Datasheet View->Yes and Default View->Datasheet it might make it more obvious.

That said, I mocked up the tables from post #1 and your macro code from post #4 and it works for me. Maybe you have a required field in the stock_tbl that you've forgot to set as well?

productRef field (foreign key) from stock_tbl is linked to product_tbl 's productID (primary key). Maybe that's why...

yep... i setfield productref = 2 and it works.