Hi everyone
Vague heading I know -
What I am tryng to do is get a list on a form ... easy enough
I have my mainform and its child Mainfrm-Childfrm and this relation is fine
now I want to add on another say grandchild
Mainfrm childfrm
Dave simon
daisy
now when I do simon - has a relation of Liz and George and list these on a form - they also show up on Daisy relation on the form
each has a table
maintbl
childtbl
grandchild tbl
how do I get that only simons show on the form and if Daisy has none -(or say peter and susan) that they show up
the form is a continuous form with a list field on it
(I hope i have explianed this )
screen shot