Dynamics Community Forum Thread Details

Adding PV to new object

Hello All,

I am new to Dynamics SL and am stuck on something. Up to this point, I have been using fields already available in tables to modify screens. I have a new need to create 2 new tables, one to use to retrieve possible values and another to store the values correlated with the Vendor ID. I have created the two new tables. In my internet searches I have put some code together to achieve my results. I have no VB errors but when attempting to add the new PV, the screen crashes. I created a stored procedure, created a PV file and imported it in. Below, I have my stored procedure setup, property window and PV file that was imported.. Can anyone lend a hand in something I may be missing?

Stored Procedure:
Create Proc All_NAICS @parm1 varchar ( 10) as
Select * from NAICS_Code where NAICS_Code like @parm1 order by NAICS_Code

PV File Code:
"All_NAICS","0327000","","Select * From NAICS_Code Where NAICS_Code like @parm1 order by NAICS_Code","NAICS","NAICS_Code.NAICS_Code;NAICS Code;004;0","NAICS_Code.NAICS_Desc;NAICS Desc;105;NAICS1"

Property Window