I have created a custom tab called "Members". There is a custom field called "Member ID Number" - information entered into this field is a combination of letters and numbers, so I set the field up as a text box. However, we're running into trouble with this field in specific reports we're trying to pull.
When we pull a report for invoicing and try to add our "Member ID Number" field to the report, we are getting a weird looking number and the number/letter combo we have in the text box is not being picked up.
For example, one of our members has a Member ID Number of 325, so when we put this record into our system, we filled the "Member ID Number" field (box) in with the number 325. However, when we add the "Member ID Number" field to a customized report, we get a number/letter combo that looks like this: a1AC0000000gDvw.
Every record in our system is showing a different combination of letters and numbers like the one listed above, so it looks to me like this is being automatically generated from somewhere else in the Salesforce system, but I don't know where that could be.
We do not have any other tabs with a customized field that would produce a number that looks like this.
Even more strange is that even when we have NOT entered a Member ID Number into the field, we're still getting something that looks like the letter/number combo I posted above.
Help?
You are pulling the Salesforce default ID for the custom object you are using - Membership. This is NOT the same as the custom field you are calling Membership ID. I'd suggest you rename your Membership ID field to say, "Membership Number". Then when you do your report, you won't run into this confusion.
