I am trying to populate a dropdown list (year which is a FK in a budget table) The year has the following fields (Objectuid uniqueidentifier (PK), name varchar(30), IsActive,IsDeleted.......). The budget table has (Objectuid Uniqueidentifier (PK), yearID uniqueidentifier (FK), name, ......)
The yearID field in the Budget page displays all the Names currently. I want to show Only those items in YearID that are ISACTIVE=1 in the database). I want to do this on a Load page.
How can I achieve this ?
The yearID field in the Budget page displays all the Names currently. I want to show Only those items in YearID that are ISACTIVE=1 in the database). I want to do this on a Load page.
How can I achieve this ?