date fromDate = dateNull();
date toDate = dateMax();
select validTimeState(fromDate, toDate)
FirstName, LastName from dirPersonName
join dirPerson
where dirPersonName.Person == dirPerson.RecId
join dirPartyTable
where dirPerson.RecId == dirPartyTable.RecId
&& dirPartyTable.RecId == custTable.Party;
that what I have used, Nickalaos isn't it feasible to get the values from the First Name and Last Name controls from DirPArtyQuickCreateForm, actually they are dynamically used and I didn't find the way how to do get their values in the eventhandler?
Also i tested this querry it is also missing the values sometimes, just for knowledge i am using it in the Inserted event of custTable, since I have to save the generated value in CustTable.