AnsweredAssumed Answered

help me please

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

Title

help me please

Post

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

Screen_shot_2012-06-29_at_3.26.19_PM.png

Outcomes