Filter only record that has sub-record? (1 Viewer)

[calvinle]

My Table 1 is linked to Table 2:
[id-PK] 1 to many [Date_id]

Table 1:
[id-PK] - [Date]

Table 2:
[id-PK] - [Date_id] - [Item]

I have insert the Table 1 as subform on a form, so I am wondering if it's possible to filter the subform to only display record in table 1 only those that has record in table 2.

Thanks

 

[AccessBlaster]

It seems odd to have a parent record without the child record or vice versa.

 

[calvinle]

Right, but the date is generated automatically, and the items is only if we have orders. Unless I supress the date on daily basis which I don't need I need to since it doesn't impact anything, except creating useless record, but I might need that date in case of retro items.