Match Records from One Database to Another

[CJ]

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