D
don
I'm looking to validate products against varying purchase criteria.
On the Purchase criteria side; I have a parent table of clients, with
related child table of purchase criteria for those clients. Also a related
states table to indicate which states the product is sold for each of the
clients.
On the item side, there is a PolicyInfo table with some fields which must be
validated (Face amount, rating, etc), then related child tables for things
like:
owners (state)
insureds (age)
LEs (min, max amounts, counts)
and several other child tables related by CaseID to the PolicyInfo table.
My question is, how can I loop thru the various parent/child data on both
sides of this?
I built a join query to represent the criteria side, and was able to get
alot of it to successfully compare against what was in the current form. Of
course, the query kind of slow..
I think I need a more iterative approach (for other forms, and for report),
so can run for all CaseIDs, rather than only the current CaseID on this 1
particular form.
Any ideas appreciated -
On the Purchase criteria side; I have a parent table of clients, with
related child table of purchase criteria for those clients. Also a related
states table to indicate which states the product is sold for each of the
clients.
On the item side, there is a PolicyInfo table with some fields which must be
validated (Face amount, rating, etc), then related child tables for things
like:
owners (state)
insureds (age)
LEs (min, max amounts, counts)
and several other child tables related by CaseID to the PolicyInfo table.
My question is, how can I loop thru the various parent/child data on both
sides of this?
I built a join query to represent the criteria side, and was able to get
alot of it to successfully compare against what was in the current form. Of
course, the query kind of slow..
I think I need a more iterative approach (for other forms, and for report),
so can run for all CaseIDs, rather than only the current CaseID on this 1
particular form.
Any ideas appreciated -