G
Guest
I need to know why in my Access Project I can not add additional records
after entering a parameter to filter some records. For example I want to see
only records from Atlanta(siteid) & then add additional records from the same
form.
ALTER FUNCTION dbo.Function4
(@site int)
RETURNS TABLE
AS
RETURN ( SELECT dbo.tblChecklist2.ChecklistID,
dbo.tblChecklist2.InDate, dbo.tblInvAtl.BarCode, dbo.tblInvAtl.SerialNumber,
dbo.tblInvAtl.Model, dbo.tblInvAtl.Location,
dbo.tblInvAtl.UserName, dbo.tblInvAtl.SEID,
dbo.tblInvAtl.InvID, dbo.tblChecklist2.InvUpdate, dbo.tblChecklist2.PCName,
dbo.tblChecklist2.LogonId,
dbo.tblChecklist2.SiteID
FROM dbo.tblChecklist2 INNER JOIN
dbo.tblInvAtl ON dbo.tblChecklist2.InvID =
dbo.tblInvAtl.InvID
WHERE (dbo.tblChecklist2.SiteID = @site) )
after entering a parameter to filter some records. For example I want to see
only records from Atlanta(siteid) & then add additional records from the same
form.
ALTER FUNCTION dbo.Function4
(@site int)
RETURNS TABLE
AS
RETURN ( SELECT dbo.tblChecklist2.ChecklistID,
dbo.tblChecklist2.InDate, dbo.tblInvAtl.BarCode, dbo.tblInvAtl.SerialNumber,
dbo.tblInvAtl.Model, dbo.tblInvAtl.Location,
dbo.tblInvAtl.UserName, dbo.tblInvAtl.SEID,
dbo.tblInvAtl.InvID, dbo.tblChecklist2.InvUpdate, dbo.tblChecklist2.PCName,
dbo.tblChecklist2.LogonId,
dbo.tblChecklist2.SiteID
FROM dbo.tblChecklist2 INNER JOIN
dbo.tblInvAtl ON dbo.tblChecklist2.InvID =
dbo.tblInvAtl.InvID
WHERE (dbo.tblChecklist2.SiteID = @site) )