I want to create a field that is a Lookup from a different table, but I want to set the criteria dynamically based on a previous selection of the user:

Example:

Table Clients has String Company_name, String Address 

Table Contacts has String Full_name, Company:=Lookup from Clients.Company_name

I want to create a third form that will contain a Lookup from Clients and a lookup for Contacts

After selecting a Client and going to selecting a Contact, only contact from the same company as the client will be shown

I know how to create a static criteria for a look up, but how do i create a criteria based on previous selection in that form?