Can anyone please help with this? I have the following tables ....
Group_Phase Group_ID Phase_ID Phases Phase_ID Phase (Nursery, Primary, Secondary, Special) Report_Names Report_ID Group_ID Report_Name Report_Groups Group_ID Report_Group (Panda, Plasc, KS1,KS2 etc...) Access Access_ID Report_ID Access_Rights Path_Name Doc_Type_ID Doc_Type Doc_Type_ID Doc_Name( doc pdf etc used for drop down) Doc_Type (.pdf, .doc, .xls etc..) There are groups of reports that can be associated with one or more phases eg. PANDA reports exist for Primary, Secondary & Special PHASES I am going to pass two parameteres to a query which are Group_ID (Which will give the report groups) and Phase What I want to recieve is all the documents associated with this Group_ID and Phase I have tried to build the query in an SQL 2000 view but I can't get it to work at all.... I have bitten the bullet here and had a go at redesigning some of the tables and it appears to have backfired in my face ..... Can anyone help please..... Regards - Paul ************************************************************************************************* The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 6666. Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. ************************************************************************************************* -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
