G
Gnaeus
Hi, all
could someone help me?
In my business, i need to organize projects by ID (a sequential number), not
by Project Name, as BCM do. So, i looked the BCM SQL Table and it really
creates a sequential number for any project we enter. But, BCM do not show
this number and not give an option to do it.
Well.. i solved this problem partially: i created an user-field, named as
Project ID and i am inserting manually this ID. But it is too much tedious
because i have to look inside the SQL Server for the correct number recently
added.
My question is simple: are there any way to show the SQL ID for projects?
If there is no native BCM options to do it, maybe using VBA? Or creating a
trigger in SQL Server populating the recently project ID added into my
user-field in SQL Server?
I really do not know why Microsoft did not give us an option to access the
SQL primary key that index Projects. We can show and configure many, many
fields.. but not the Project ID...
Thanks for any information
Alex Albuquerque
could someone help me?
In my business, i need to organize projects by ID (a sequential number), not
by Project Name, as BCM do. So, i looked the BCM SQL Table and it really
creates a sequential number for any project we enter. But, BCM do not show
this number and not give an option to do it.
Well.. i solved this problem partially: i created an user-field, named as
Project ID and i am inserting manually this ID. But it is too much tedious
because i have to look inside the SQL Server for the correct number recently
added.
My question is simple: are there any way to show the SQL ID for projects?
If there is no native BCM options to do it, maybe using VBA? Or creating a
trigger in SQL Server populating the recently project ID added into my
user-field in SQL Server?
I really do not know why Microsoft did not give us an option to access the
SQL primary key that index Projects. We can show and configure many, many
fields.. but not the Project ID...
Thanks for any information
Alex Albuquerque