OK I'm back and this time I actually have a question I believe may prove tricky.
My application has 2 different datasources. One of these is locked so no edits can be made. The other is freely editable. I have a tool that allows the user to decide what records they wish to include in the editable section. Hope I did not lose to many people there.
Now if someone looks up a record with a order history and one of the customers has not been added to the local data yet. I need a way for this to be done. I have a field that actually contains the key field information in it so that a comparison and lookup is made easy.
What I need to do is have it so that when an event (button/click/doule click field) the program first checks to see if this record is contained locally. If it is not it prompts the user asking if they wish to add this user to the local listings. At this point the data is grabbed from one datasource to the local one and the local record is opened.
I know this may sound confusing , but I would really appreciate any assistance here.
Thanks in Advance
My application has 2 different datasources. One of these is locked so no edits can be made. The other is freely editable. I have a tool that allows the user to decide what records they wish to include in the editable section. Hope I did not lose to many people there.
Now if someone looks up a record with a order history and one of the customers has not been added to the local data yet. I need a way for this to be done. I have a field that actually contains the key field information in it so that a comparison and lookup is made easy.
What I need to do is have it so that when an event (button/click/doule click field) the program first checks to see if this record is contained locally. If it is not it prompts the user asking if they wish to add this user to the local listings. At this point the data is grabbed from one datasource to the local one and the local record is opened.
I know this may sound confusing , but I would really appreciate any assistance here.
Thanks in Advance