link parent to child table

[jerry28ph]

I have main form (called frmPCLog) and I had 5 queries with different results (like sum, count, totals etc.). I need to get those results in queries and put it all together in a single form using text box, and save it in another table (name tab_report) for report purposes. I got a suggestion to use sub forms to link my parent table to child table using common fields.
Please im asking again your help how to facilitate this processing of linking parent to child fields.

I hope you get my point.
Thanks

Best regards,
JErry

 

[John Big Booty]

The sub form wizard will walk you through this process.

Also it is generally considered bad practice to store calculated fields. If you can calculate the field to store it, you should in most cases be able to calculate it at the point where you need to display it. So why waste space be storing something that can be calculated on demand?