Problem : actionCreate for 2 relaed tables

Yii 1.1 General Discussion
1

I have 2 tables (with their related models)

Report -> model : Report

id , title

Attachment -> model : Attachment (with report_fk foreign key to Report table id field)

id , file , report_fk

This application has a form with fields from Report and Attachment both on the same page with one submitButton that it saves both models





actionCreate for Report

---------------------------------


model1 = new Report;

model2 = new Attachment;


.......


if ($model1->save()  &&  $model2->save()) {


....


}

Issue :

When a user creates a new report and he attaches some file to the report that they will save in Attachment table I can’t fill the report_fk. when I run actionCreate on Attachment controller it got error coz its report_fk can not be null and I don’t know the report id coz Report record will save after Attachment record is saved. it’s a problem about sequence.

2

SOLVED

it works now




if ($model1->save() )

	{

    	if ($model2->save() ) 

		{

			.....

		}

	}