I have found that a UNION Query will allow me to see all 6 pieces of information from six different colums of information in one place. I have an insurance carrier that writes Life Insurance, Short Term Disability Insurance, Long Term Disability Insurance and Dental Insurance. I have the Carrier Name for each of these lines of insurance stored in seperate colums of a table. I want to view them all in one form at one time and the UNION QUERY will do that just fine... except I want to be able to edit the commission information in the UNION QUERY all on one form. The UNION QUERY will not let me edit. Does anybody have any ideas how to pull all six pieces of information together and show it on one form and have the ability to edit it?
I hope my question is clear.
Thanks,
Bill in MN, where the cold means it is programming season.
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar