N
nycdon
i'm taking over db that was basically one flat file, and breaking into
parent-child tables. The data validation was done with vba with command
button, and actual messages, and resulting status were stored on the row.
It seems the messages and status should be calculated, rather than stored..
though made it easier to run reports..
My issue is a strategy to handle the validation for parent and child data,
but not just for the single current row on form, but also to be used to
report on all/some of the rows for a report..
Initially..I started with query to validate child rows (owners) for parent
row (PolicyInfo/PolicyID), to check owner(s) DOB valued, name, etc. Then
another query for child rows (Brokers) for parent row (PolicyInfo/PolicyID),
where broker's info is valdated..
I thought to run all these queries, then join them to grab all the
messages...but queries not all same nbr of columns, so union not feasable I
think.
how can i get all these messages in 1 place...and do it so I can run for
current row on form, and for all/some rows for a report?
any ideas greatly appreciated!
thanks!
don
parent-child tables. The data validation was done with vba with command
button, and actual messages, and resulting status were stored on the row.
It seems the messages and status should be calculated, rather than stored..
though made it easier to run reports..
My issue is a strategy to handle the validation for parent and child data,
but not just for the single current row on form, but also to be used to
report on all/some of the rows for a report..
Initially..I started with query to validate child rows (owners) for parent
row (PolicyInfo/PolicyID), to check owner(s) DOB valued, name, etc. Then
another query for child rows (Brokers) for parent row (PolicyInfo/PolicyID),
where broker's info is valdated..
I thought to run all these queries, then join them to grab all the
messages...but queries not all same nbr of columns, so union not feasable I
think.
how can i get all these messages in 1 place...and do it so I can run for
current row on form, and for all/some rows for a report?
any ideas greatly appreciated!
thanks!
don