This is my first post ever but I have benefited from others so let me start off by thanking everyone who takes their time to help those who post on these boards. Your assistance is worth its weight in gold.
I'll try and keep simple but I think I need to explain a little. I have a database that covers 14 or more programs we run. Each has up to 50 or more contractors so I have it designed that from a main form the data entry person will select a program which will populate a list of our current providers. They select that provider and a split form will open up to allow them to enter data and display that providers data. I chose to have a different table for each program because payment points etc. are not the same across programs. However the one thing that is constant across programs is obviously names of clients.
So I created a union query (clients enrolled) to list all clients in all programs. Then on the form side of each split form I have it look for any duplicates on the query on the before update event of the name fields. That works perfectly as to alert me to a possible conflict/duplication. However, what I would like to know is there a way to somehow display those results in either a message box or some other type of pop-up so that the person entering would know where the possible duplication exists because duplication might be ok, but this would give the person knowledge of where they could find the relevant record (program/provider).
For example: They type in John Smith and it alerts to a duplication for John Smith under program "X" contractor "123" and also under program "y" contractor "2" This could then be discussed a to whether it is ok or if a client is being provided duplicate service.
Sorry for length of post,
Poz
I'll try and keep simple but I think I need to explain a little. I have a database that covers 14 or more programs we run. Each has up to 50 or more contractors so I have it designed that from a main form the data entry person will select a program which will populate a list of our current providers. They select that provider and a split form will open up to allow them to enter data and display that providers data. I chose to have a different table for each program because payment points etc. are not the same across programs. However the one thing that is constant across programs is obviously names of clients.
So I created a union query (clients enrolled) to list all clients in all programs. Then on the form side of each split form I have it look for any duplicates on the query on the before update event of the name fields. That works perfectly as to alert me to a possible conflict/duplication. However, what I would like to know is there a way to somehow display those results in either a message box or some other type of pop-up so that the person entering would know where the possible duplication exists because duplication might be ok, but this would give the person knowledge of where they could find the relevant record (program/provider).
For example: They type in John Smith and it alerts to a duplication for John Smith under program "X" contractor "123" and also under program "y" contractor "2" This could then be discussed a to whether it is ok or if a client is being provided duplicate service.
Sorry for length of post,
Poz
