Child Fields not Linking to Master Fields

  • Thread starter Thread starter CSDunn
  • Start date Start date
C

CSDunn

Hello,
I have a subform in which the record source is the following Stored
Procedure:

***********************************************

Create Procedure WOApproveAccess_sp
AS

IF
(Select Count(AD.WODistrict)From tblMMAdmins AD
Where AD.WODistrict <> 0
and AD.SystemUserName = (system_user))>0

Begin
Select WO.WoSiteID, WO.WOapproved, WO.WorkOrderID
From tblWOWorkOrder WO
End

Else

Select
WO.WOSiteID, WO.WOApproved, WO.WorkOrderID
From tblMMAdmins AD Inner Join tblWOWorkOrder WO
On AD.Schoolnum=WO.WOSiteID
Where
AD.WOSite <> 0
and
AD.SystemUserName = (system_user)

***********************************************

The Child Field in this record source is supposed to be 'WO.WorkOrderID',
which is supposed to link to the Master Field in the main form called
'WO.WorkOrderID'.

For some reason, the fields are not linking. When I drag the subform into
the details section of the main form, the Child and Master Field properties
are empty. When I go through the add subform wizard, I get the same result.

What could be causing the problem with the Child and Master linking fields?

Thanks!

CSDunn
 
Back
Top