Display replationship 1-M

[Dinh Hien Phan]

Hello all,

In Family detail, I want to show a grid which display all member in that family (table Dependant),
I have added form reference in form edit but grid show all records of table dependant.

<?xml version="1.0" standalone="no"?>
<EasyView Name="FamilyEvaluationEditView" Description="Pigs.FamilyEvaluation.Detail" Class="EasyView" Tab="" TemplateEngine="Smarty" TemplateFile="view.tpl" Access="pigs.familyevaluation.Access">
   <FormReferences>
        <Reference Name="Pigs.FamilyEvaluation.form.FamilyEvaluationEdit" subforms="Pigs.Dependant.form.DependantListForm"/>
        <Reference Name="Pigs.Dependant.form.DependantListForm"/>
   </FormReferences>
</EasyView>

Please give me some advices,

Thanks,
Hien Phan

[Openbiz.me]

You need to add the Dependent data object as ObjReference (1-M) of the Family data object. Then the subform should show data only for the given family.

Sent from my iPhone

[Dinh Hien Phan]

This is Family data object:

<?xml version="1.0" standalone="no"?>

<BizDataObj Name="FamilyEvaluationDO" Description="" Class="BizDataObj" DBName="Default" Table="person" SearchRule="" SortRule="" OtherSQLRule="" Uniqueness="" Stateless="N" IdGeneration="Identity" CacheLifeTime="0" CreateCondition="pigs.familyevaluation.Manage" UpdateCondition="pigs.familyevaluation.Manage" DeleteCondition="pigs.familyevaluation.Manage">
    <BizFieldList>
        <BizField Name="Id" Column="idPerson" Type="Number"/>
        <BizField Name="idFamily" Column="idFamily" Required="N" Type="Number"/>
        <BizField Name="idAddress" Column="idAddress" Required="N" Type="Number"/>
        <BizField Name="idRelationship" Column="idRelationship" Required="N" Type="Number"/>
        <BizField Name="relationship" Join="relationship" Column="Type" Required="N" Type="Text"/>
        <BizField Name="Surname" Column="Surname" Length="25" Required="N" Type="Text"/>
        <BizField Name="FirstName" Column="FirstName" Length="25" Required="N" Type="Text"/>
        <BizField Name="FullName" Column="FullName" Length="50" Required="N" Type="Text"/>
        <BizField Name="Gender" Column="Gender" Required="N" Type="Number"/>
        <BizField Name="DOB" Column="DOB" Required="N" Type="Date"/>
        <BizField Name="Age" Column="Age" Required="N" Type="Number"/>
        <BizField Name="Photo" Column="Photo" Required="N" Type="Text"/>
        <BizField Name="ThumbNail" Column="ThumbNail" Required="N" Type="Text"/>
        <BizField Name="FileName" Column="FileName" Length="250" Required="N" Type="Text"/>
        <BizField Name="CreatedDate" Column="CreatedDate" Required="N" Type="Datetime"/>
        <BizField Name="CreatedBy" Column="CreatedBy" Length="50" Required="N" Type="Text"/>
        <BizField Name="ModifyDate" Column="ModifyDate" Required="N" Type="Datetime"/>
        <BizField Name="ModifyBy" Column="ModifyBy" Length="50" Required="N" Type="Text"/>
        <BizField Name="Status" Column="Status" Required="N" Type="Number"/>
       
        <BizField Name="idHost" Join="host" Column="idHost" Type="Text" Required="N"/>
    </BizFieldList>
    <TableJoins>
        <Join Name="relationship" Table="relationship" Column="idRelationship" ColumnRef="idRelationship" JoinType="LEFT JOIN"/>
        <Join Name="host" Table="host" Column="idPerson" ColumnRef="idPerson" JoinType="LEFT JOIN"/>
    </TableJoins>
    <ObjReferences>
        <Object Name="Pigs.Dependant.do.DependantDO" Relationship="1-M" Table="dependant" Column="idHost" FieldRef="idHost"/>
    </ObjReferences>
</BizDataObj>

Did I have any mistakes?

[Arnold Chitwa]

FieldRef ="Id" Assuming the Column="idHost" thats the first mistake.

Regards

Chitwa

[Dinh Hien Phan]

Thanks all,

My mistake is call wrong name of BizDataObj.

[Dinh Hien Phan]

But I have another question,
When I create a dependant record, How can I get idHost from master form?

[Agus Suhartono]

please share your database design

[Dinh Hien Phan]

Hello Agus Suhartono,

Please take a look at this topic https://groups.google.com/forum/?hl=en&fromgroups#!topic/openbiz-cubi/MuFRzy6cLJA
It is same as my requirement.

Thanks,
Hien Phan