Hello everyone,

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

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...

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.

Thank you

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.

See attached.

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.

I see I was too slow ... LOL. Well, Coach can blame it on a client, I had a baby to deal with!

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.

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"....

Any client who has you on the phone this late at night ... I see what you mean.

The attachments shouldn't be read-only. You should be able to edit them.