Unable to show non numeric primary key in tables?
I have the current schema in
However, the busnumber seems to print out to 0 on the form. The rest is printing out fine. Could this be because
busnumber
is a primary key?8 Replies
why would make a primary key that can be entered?
Isn't it logical to have a primary key when it's unique? Carplate are unique so i don't think there's a problem right?
primary should be one? unique doesn't need to be primary
But carplates are unique and only have 1 also right? Should i just change it to numeric then have another field and make it unique?
don't know how it stored. by i guess it could be just a string
Solution
All we needed is
thanks solved my problem