Sorry, hit a button or something...
The problem is that a filtered drop list list not displaying anything. If the list is unfiltered, it displays everything, which is not desired. So my filter is no good and I think it has to do with context. Go with me a bit here...
Object tree looks like this...
PHS
-----Landlord
------------Neighbor
Neighbor is an attribute of Landlord and of PHS, owned by both.
When entering a Neighbor from a list on the PHS form, I place the Landlord attribute as a drop list on the Neighbor form and filter so that I only fetch Landlords from the same PHS that I started on.
The filter query is:
FIND Landlord WHERE Landlord.PHS.ID=ThisPHS.ID
Can I presume that PHS is in context when the NEW Neighbor form is initialized? Because it seems not to be.
Any quick thoughts from smart guys?
