AnsweredAssumed Answered

help me please

Question asked by applelakshan1 on Jun 29, 2012
Latest reply on Jun 29, 2012 by philmodjunk


help me please


Hello Guys , 

In My solution i have 3 tables 

01. Transactions 
02. Accounts 
03. subaccounts 

the relationship is 

transaction=------= Accounts =------=subaccounts 
transaction id -------->accoutransid-----------> Subaccid
X X 

Accounts can create data in transaction table and subaccounts both. it works well

my question is when new record create on transaction table, i want to pull subaccount name from subaccount table an copy it to one field in transaction table 

any help appreciated