Parent\Child Tables

[VBNewby]

How can I ensure that the currently selected row ID in Parent Table automatically appears in my child form when I create a new row in the Child Form.


I am using VB 2008 Express

I have a Stored Procedure for the chiled table called "Files" can I do it from there:-

ALTER PROCEDURE dbo.CreateFile
		(
	@FileName varchar(50),
	@DateCreated varchar(50),
	@CreatedBy varchar(50),
	@Filetype varchar(50),
	@Folder varchar(50),
	@FileClassification varchar(50),
	@Re varchar(50),
	@Modified Timestamp OUTPUT,
	@FileID int OUTPUT,
	@FolderID int OUTPUT
	)
	
AS
	SET NOCOUNT ON
	
	-- Inserts New Row
	
	INSERT INTO Files
	( FileName, DateCreated, CreatedBy, Filetype, Folder, FileClassification, Re, FolderID )
		VALUES
	( @FileName, @DateCreated, @CreatedBy, @Filetype, @Folder, @FileClassification, @Re, @FolderID  );
	

	
	IF @@ROWCOUNT>0 AND @@ERROR=0 -- Checks if Last Statement Produced an Error
	
	-- 
	
	SELECT @FileID = FileID,
	@Modified = Modified,
	@FolderID = FolderID	
	
	FROM Files
	WHERE (FileID = SCOPE_IDENTITY());

[BrailleSchool]

this post should be in the database development forum