Lookup to get keys..

mishra.hanu@yahoo.co.in

• July 28, 2008 00:00

• Answered

Follow

Hi jaro,


I have a requiremnt that, there is one csv file having two fields(institution_id,consortia_id). I have one DB table accounts which is having the entry of booth the fields in the code column of the accounts table and generate primary key for both now i want to fetch primary key fro them

example:-

file name:- consortia_memberds
fields:- institution_id,consortia_id
records are in the file like this

1002, "TWN"
1003,"SPM"

here intitution_id is parent and the consortia_id is the child.

I loaded seperate files for both of them which generated primary key for them.

Now i want to find primary key for institution_id and the consortia_id from DB after and want to make entry in the parent_child table.

My issue is that how can i get key fot the field institution_id and the consortia_id altogether.

Please help if have any idea..


Thanks

• 

  avackova

  • December 17, 2009 10:48

  0

  Comment actions Permalink

  Hello, I'm not sure if I've understand you well, but I think you look for DBJoin or LookupJoin component.

Please sign in to leave a comment.