# Lookup to get keys

**URL:** <https://forum.cloverdx.com/t/lookup-to-get-keys/363>\
**Category:** CloverDX Platform\
**Created:** [July 28, 2008, 12:00am UTC](https://forum.cloverdx.com/t/lookup-to-get-keys/363 "2008-07-28T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mishrahanuyahoocoin](https://avatars.discourse-cdn.com/v4/letter/m/d9b06d/32.png) [@mishrahanuyahoocoin](https://forum.cloverdx.com/u/mishrahanuyahoocoin)\
**Post date:** [July 28, 2008, 12:00am UTC](https://forum.cloverdx.com/t/lookup-to-get-keys/363/1 "2008-07-28T00:00:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [December 17, 2009, 10:48am UTC](https://forum.cloverdx.com/t/lookup-to-get-keys/363/2 "2009-12-17T10:48:53Z")

</div>

Hello, I’m not sure if I’ve understand you well, but I think you look for [DBJoin](http://wiki.clovergui.net/doku.php?id=components:joiners#dbjoin) or [LookupJoin](http://wiki.clovergui.net/doku.php?id=components:joiners#dbjoin) component.