Hi
like to run a design concept past to see if I'm approaching it the correct way.
I have a two table database tbl_Parish and tbl_church, each parish can hold several churches so its a one to many relationship.
I want a way that on the opening form the user can select a parish and church and limit record selection to that range.
My though was set up two combo boxes one for church and one for parish and when the opening form is closed move the two values from those boxes into temporary variables.
Then when I create my queries use those temporary variables as criteria.
Am I over thinking this? or is this as good a method as any?
thanks
Ian