Match Records from One Database to Another

[Craig McPherson]

This example uses a lookup...there are many ways to approach this...
assuming Lname is the common field...and there is a field called 'Address'
in the B file...one way would be:

local lAddress
lAddress = lookup("A","Lname",Lname,"Address","",0)
field Address
cell lAddress

run the procedure to autofill the Address field...or perhaps put it in a
.ModifyRecord procedure
You could also use the grabdata function to fill the field..I use grabdata
for a sales database to autofill several fields when the Orgname is the same
as a previous order and I am sure there are no duplicates....Note that if
you have multiple Lnames which are the same, only the first match will be
found, so you need to make sure that the common field is a unique value for
every record...some kind of matchfield like a unique number for the common
field or a concatenation like Lname+Fname...

Not sure what you mean by all the records are in both files...the lookup or
grabdata will only work in one direction, not both.
Craig McPherson

On Tue, Jul 22, 2008 at 10:12 PM, Jay Schille <jayschille at gmail.com> wrote:

> Craig,
>
> More specific information, please. Is this common field a key field
> (like an ID#) that links the two files? If not, why does it have to
> appear in both files?
>
> >New Panorama User here:
> >
> >I have 2 files.  There is one common "Field" in both files.  I
> >manually enter the Field in File A.  How can i have File B "lookup"
> >that field in File A everytime I open File B and update so that all
> >records are in both Files?
> >
> >Thanks
> >
> >Craig
> >
> >
> >_______________________________________________
> >Qna mailing list
> >Qna at provue.com
> >http://provue.com/mailman/listinfo/qna
>
>
> --
> Jay Schille
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080722/a7ebed4d/attachment.html