Join two Forms

HCL Domino Domino Forum
1

Hi

I have a view in which i need to display the result of 2 forms. Below are the 2 forms and its fields

Form1: Student

sName Class Tutor Grade

XXXX 2 Alicia 72

YYYY 2 Alicia 42

WWWW 2 Alicia 72

QQQQ 3 ROSE 62

HHHH 3 ROSE 72

AAAA 5 HILTON 92

Form2: Tutor

TName Class Subject oTHERS

Handled

OOOO 2 ENGLISH sPANISH,MATHS

KKKK 3 MATHS GERMEN

TTTT 5 SCIENCE ENGLISH,FRENCH

YYTE 8 ART CRAFT, GAMES

I want to display tutor and their students as follows

Tname class subject sName Grade

OOOO 2 ENGLISH

		XXXX	72

		YYYY	42

		WWWW	72

KKKK 3 MATHS

		QQQQ	62

		HHHH	72

TTTT 5 SCIENCE

		AAAA	92

YYTE 8 ART

HOw can i do this?

2

Subject: Join two Forms

i see only two ways:

  1. you will change type of “students document” to children type (the teacher will be parent for them).

  2. you can try to play with category (perhaps you will need to save data about teacher in student’s documents).

probably that’s all

3

Subject: Join two Forms

In view selection criteria select both the forms.SELECT From=“Tutor” | Form = “Student”.

Then categorize the Tutor column.

Also you could create a column with column formula specified - instead of directly giving a field name. Something like:

@If( Form = “Tutor”; TutorName; StudentName)

regards

Litty Joseph