Create record in two tables

[Fairlane]

I have several tables: tblStampOrd, tblAssets, tblComponents. This is a recording database for incoming items. Some of these items are just fine the way they are and only hit the assets table. Others have a number of components.



I have a form based on tblStampOrd with a subform for tblAssets. Is there a way to create record on one line that hits the Assets table but also creates a blank (not Null) record in the components table so that I can create a report on Assets and sub-components? Or design the report to report Assets with no components?

I have attatched a simple form of my DB that shows the issue. Notice that the fourth asset does not show on report at all. TIA

Cannot get attatchment to work so I have it here:
https://www.dropbox.com/s/jfy7r7un8sxwt3f/Sample.accdb

[ItsMe]

Not sure the purpose of creating a "Blank" record but, you can populate a text field with an empty string and save the record using VBA. You could probably use some DoCmd.GotoRecord lines of code to get the job done. I would probably use DAO to write to the table and then Requery the subform.

[Fairlane]

I found a way to do it finally. Turns out that you CAN have a subform in a report and that does the trick. Just wish I could do the same in my entry forms.

[ItsMe]

...Or design the report to report Assets with no components?...

You can use the Wizard to create a query. If you select the "Find Unmatched Records" option, you can create a query to locate companies with no records in the asset table.