Nov 15 2005, 01:23 AM
I have this simple personal database that i have just created to kep track of my bills and other stuff. My problem as you will see is that in the rptBalance in the detailed section the transaction is repeated under each catagory where it was suppose to be under the one catagory it was assigned to.
for example you will see the payment of $25.00 given to the Car Activity and it is listed under Gas, Maint.. Insurance and all other catagories for the car. I want that to show for only one. In this example the $25.00 was suppose to be for gas only. What am i doing wrong.?
Thank you all and excuse my little basic question
Nov 15 2005, 02:01 AM
The way you have it set up know there is not any relationship between tblDetail and tbltransactionID
I do not think your tables are not properly related. I think that the table tblDetail should be related to tbltransactionID . And the table tblActivityID should only be related to tblDetail.
I will see if I can fix it an post it back.
I will return on a few minutes...
Nov 15 2005, 02:05 AM
Could i possibly be any more demanding and ask you to make the quick relationship and post it. I hate to ask but if i get a better picture. I may not have to start from scratch.
Nov 15 2005, 02:14 AM
Sorry it took so long to get is fixed (over 5 minutes) . I usually am faster than this. I was also helping a client on the phone at the same time.
Nov 15 2005, 02:16 AM
You had a couple of basic issues in your form design, primarily in that you were not storing the DETAILID in your transactions table, but rathe the ActivityID for a second time.
With that cleaned up, it was a simple matter of fixing the JOINs in the recordsource of your report.
Nov 15 2005, 02:19 AM
I see I was too slow ... LOL. Well, Coach can blame it on a client, I had a baby to deal with!
Nov 15 2005, 02:21 AM
Thank you both for the help. I think i am going to start from scratch so i would know what i am doing incase i add on to it.
I think it is neat how you can send the attachment as read only.
I am guessing changing that on my computer is out of the question. lol
thank you both again. I am glad that professionals like yourselves are here and give their time to noobies like myself.
Nov 15 2005, 02:23 AM
This client is just as demanding as a small child. I have a few that are llike like having kids.
Peter, we sure think alike. At least in "theory"....
Nov 15 2005, 02:27 AM
Any client who has you on the phone this late at night ... I see what you mean.
Nov 15 2005, 02:28 AM
The attachments shouldn't be read-only. You should be able to edit them.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here