Thanks for the sample, I like that and can see how it's working I think. It looks to me like the tables don't reference each other, the form references them both.
What if I'm trying to reference tables directly though? If I have tbl_clients and tbl_sites, where one client may have several...