Hi guys,, im having problem with my stored procedure. i dont know how to make it show..when i click on a particular record on my datagridview it should display another form with its corresponding laboratory records, radiology records and so on..
here is my code
ALTER PROCEDURE dbo.ViewAllLabRecords ( @lab_Record_ID int ) AS SELECT * FROM Laboratory_Records LR JOIN PT_Chart PTC ON LR.Lab_Record_ID = PTC.Lab_Record_ID WHERE LR.Lab_Record_ID = @Lab_Record_ID;
pls help me solve this one