Not sure where my problem lies so will tell you what I have done and what my result should be. Have primary CustomerTbl, ServiceTbl, ReasonTbl, and LocationTbl, with the 3 latter tables related to customer table.
Have a form allowing for 2 entries of facts if necessary; Customer name, Contract #, Dollar amount, and combo boxes for Reason, Service, and Location. When the 2nd set of entries are used, they are represented by reason2, service2, location2, in addition to dollars2 and are fields on the main customer table as well. Because comments are also required, I do not want the user to have to repeat this information, along with the name and contract number on a new form.
Separate queries were set up for the combo box's (link, and link2), both which draw from the Service, Location and reason tables. The form looks great. The report output is not right. If a customer only has 1 entry, his contract number shows up and all the information pulled from the combo boxes appears just fine. If 2 entries are required, the contract number shows up once, and the first line of information is good, but the second line shows up as the code letters rather than spelled out as in the 1st entry. So where the 1st line might say it was a surgery, incorrect authorization and performed at the hospital for $1600, the second set might say 2, A1, and b for $1600. I have tried reversing the details on the 2nd set of combos, but still no change. Am I doing this all wrong?
I have attached a copy of my report. I have played around with the totals, so you can disregard that for now. I will take care of that later. Thanks.
Have a form allowing for 2 entries of facts if necessary; Customer name, Contract #, Dollar amount, and combo boxes for Reason, Service, and Location. When the 2nd set of entries are used, they are represented by reason2, service2, location2, in addition to dollars2 and are fields on the main customer table as well. Because comments are also required, I do not want the user to have to repeat this information, along with the name and contract number on a new form.
Separate queries were set up for the combo box's (link, and link2), both which draw from the Service, Location and reason tables. The form looks great. The report output is not right. If a customer only has 1 entry, his contract number shows up and all the information pulled from the combo boxes appears just fine. If 2 entries are required, the contract number shows up once, and the first line of information is good, but the second line shows up as the code letters rather than spelled out as in the 1st entry. So where the 1st line might say it was a surgery, incorrect authorization and performed at the hospital for $1600, the second set might say 2, A1, and b for $1600. I have tried reversing the details on the 2nd set of combos, but still no change. Am I doing this all wrong?
I have attached a copy of my report. I have played around with the totals, so you can disregard that for now. I will take care of that later. Thanks.
