Report gives ID number instead of value

[moocho992345]

Attachment 24254
This form is to enter the information for a ticket counting db.

Attachment 24255
The data ends up in this table

Attachment 24256
This query pulls data for the report. The data that shows up in the form is all from the TicketEventWithMyData table.

Attachment 24257
This is the rest of the query. The data in question is the StartCash


A form is used to pull up the report, filtering the data by Seller Name and Event.


Less starting cash is where the value $400 should show up... but it says 5...


After a little exploring, I discovered that the 5 that was showing up came from the ID of that value in another table.
Any ideas on why it's doing this and how I can get $400 to show up instead?

[ssanfu]

Hard to tell.... none of the attachments can be viewed. Would have to see your dB.

[moocho992345]

Thanks for letting me know. I figured it out after a while.