I have a Data connection in VS 2010 To an Access DB all Views are shown in the Data Connection accept one.
This View consists of the following 'GETLIST' Function coded in Access.
The Query works in Access Accept it is not displayed in VS.
Thanks in advance.
SELECT T.ID, GETLIST("SELECT T1.Hold From status_notes_tbl AS T1 Where T1.CustomerID =" & T.[id]," ",",") AS Notes FROM Customer_Tbl AS T;