Looking up related values

[rochard]

I have a mulltikey relationship that works perfectly. In the child file, I have 8 fields that have a related value set in dataproviders.properties. When the child record is created, I am expecting those values to be looked up and filled in but they are not. If, however, I perform a relookup

controller.relookup()

, the values appear instantly. What am I missing? TIA

[jcompagner]

can you send a small example..?

[rochard]

The records in question where the values are not being entered are being created by means of the following method:

var day1 = utils.dateFormat(indate, 'D');
var day2 = utils.dateFormat(outdate, 'D');
var between = day2-day1;
for(var i = 0; i<between;i++)
{
tblreservationroom_to_nights.newRecord();
tblreservationroom_to_nights.reservationid=reservationid;
tblreservationroom_to_nights.roomassignid=roomassignid;
tblreservationroom_to_nights.lastname=lastname;
tblreservationroom_to_nights.firstname=name;
tblreservationroom_to_nights.roomsize=pricefield
var bookdate = indate;
bookdate.setDate(bookdate.getDate() + i);
tblreservationroom_to_nights.indate=bookdate;
}

What do I have to add to the above to get it to enter the related values? TIA

[jcompagner]

which values?

[rochard]

which values?

The values in question are 8 number fields; singleWD, singleWE, twinWD, twinWE, tripleWD, tripleWE, quadWD, quadWE. They come from a pricing table which is related to the secondary table using the roomassignID and the date. As I said, the values are correctly entered if I use

controller.relookup

but not when the records are created as part of the method. Thanks.

[jcompagner]

please send me a small sample solution demonstrating this..
(else i always have to try to rebuild things from a description very time consuming and not maybe i am doing it still wrong)