I am having a little problem with a project that I am working on because I have two tables that need to be joined by a primary key, but the primary key is not an integer. I am trying to create a search engine for political contributions and the donations all have one “committee id” that is linked to a “committee”. The problem is that the every committee looks like this: C00001234 and in some cases H00VA987.
I tried to overide the process by appointing another column as my primary key, but when I do this, the column is coming up nil.
In theory I know this should be easy, but I think the problem is the that my primary key is not an integer.