I'd like to know if there is a way to have 4 tables on a form via subforms and filter all tables for one value in a search field? I've been doing this via child/master links to a combo box, but after much deliberation, I have resolved to change the datatype of all tables involved to lookups for field 'raw material'. This is because, on other forms, users rely on the lookup to find the value they need to enter.