Form Clients has a field Client.   Projects has a field Project and a field Client which is looked up from Clients.

On   Billable_Items, I want a field Client looked up from Projects.  The system won't let me do this.  It will let me do a lookup on the ID; i.e., system record number.

Then I want a field Project looked up from Projects  and filtered based on the Client selected in the first field.  This technique works fine with ID but I want users to select a client based on a name not a record number.

A picture is shown below.

Any help appreciated.

Thanks!