BizRule implementation

J

J-T

I have a table with follwoing feilds:

1)ClientID
2)EmailAddress
3)AddressDescription
4)Primary
5)BizRuleFlag

there could be multiple address for each client ,but each client **MUST**
have atleast one address with "Primary" flag set to "Y" (which mean that one
is his Primary address) and also one of the addresses **Must** also contain
an EmailAddress.I'd like to check all the data in the table and if these
rules are met set the "BizRuleFlag" to 1 otherwise to 0.

Any helps?
Thanks a lot
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

primary key - concatenated or autonumber? 6
Eliminating duplicate check box entries 4
#Name error in Query 18
Query not working as expected 7
Database design/ tables design 1
Posted in OL, Try for suggestions/comments here. 5
Link OL Contacts to Access 0
multiple tables, composite keys 1

Top