[AccessD] View with dependancy used in Acc3k.adp combo box??

William Thompson william.thompson1 at att.net
Wed Dec 1 01:09:47 CST 2004


Hi All -
Does anyone know if there would be any problems stemming from using this
'View with dependancy' (for lack of a better word) as the rowsource for a
combo box?  - Acc3k .adp, SQL Server 2k:

-- The table that holds 'parameter' is loaded from start form
-- A sproc updates the table with selection before next form loads
CREATE TABLE [dbo].[FYALL_YEAR_SELECTED] (
	[UserName] [nvarchar] (50) NOT NULL ,
	[User_Year_Selected] [int] NULL
) 
GO

-- The 'dependant' view draws recordset into combo on form 2 conditioned
-- upon year previously chosen in start form.
ALTER VIEW
vw_lkp_FYPYGroup
As
SELECT Group
FROM 
FYALLGroupRef
WHERE FiscalYearInteger
=
((SELECT
User_Year_Selected
FROM FYALL_YEAR_SELECTED
WHERE UserName = Suser_sname())-1)
GO

-- The domain table for the view
CREATE TABLE [dbo].[FYALLGroupRef] (
	[Group] [nvarchar] (120) NOT NULL ,
	[FiscalYearInteger] [int] NULL 
) 
GO

Any thoughts, suggestions appreciated.

Bill Thompson
Washington State






More information about the AccessD mailing list