Filter Table with Form Record

dyn45

hi there...
i am having some problems with filters.

In the Item Card I made a new tab and added there one table that I made previously. I have there 4 fields. in one of them i have Item."No.", number from the Item table (I am entering that number).
what I need is, when I select one Item on the General tab ex. Item0005, the table that I made should be filtered, and I should see only lines with Item0005.

I can't find out how I should do this, so please help...

dyn45

any clue...

kvb

1. Create new form with sourcetable = "your table on the new tab";
2. Add subform on a tab and set source SubFormID = "New Form ID", SubFormLink = ("Item No." = "No.");

dyn45

I can not believe how simple is that...
the last part...

thank you very much kvb