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