Data field type and length

Paul Black — Thu, 10 Jul 2008 03:57:52 GMT

Hi,

In Education : GPA field is set to accept only numeric values and not string or varchars.

I had a look at the education database table in RE (on test system) and GPA field is set to be as numeric. Can change the data type using VB?.

But what I noticed that the degree field was also a numeric field, but it's a lookup.

Education table stores corresponding numeric values of degree names and actual degree names are stored in another table.

How can we make GPA field as a lookup? At present it does not allow us to do that in config options.

I also noticed that data length are fixed for example : Campus is fixed to 50 characters only. I checked CAMPUS field in education table in database itself.

Please advise.

Regards,

Pankaj

VBA/API

Data field type and length