Showing related records on the same screen - is this a subform
I have created a rudimentary asset database and so far it's working well. There is a form for the assets that looks like this;
These assets come in and out from our warehouse and when they come back we create a condition report using another form. It's a simple one to many structure. One asset but potentially many condition reports.
I had a play with subforms when I set it up but couldn't make it work, so Condition Reports is a separate form with a lookup field for the Asset number.
I would like to have the list of condition reports below the Asset form and only those condition reports that relate the that asset.
How would I do that ? With a sub-form?