field searches on multiple databases

[kelturner]

Hi everyone,

OK, here's my question. In database1 I have created a layout in which users can search for records associated with a particular species of insect. In another database, database2, all of the insect species are cataloged and contain additional information concerning the insects biology. What I would like to do is enable the user to search for a species in database1, and then access the biology info on that same species in database2 by using a scripted button.

So far I have figured out that this would require copying the contents of the species field from database1 and pasting them into the species field in database2. At this time a subscript in database2 could run a find to pull up the information. This is what I think I need to do, but I can't get the contents of one field to copy into the contents of a field in a different database. Does anyone have any advice or tips? Thanks for the help.

-kel

[Korky]

It seems to me that you should use the copy command in a script in database1 then use the paste command in a script in database2, or am I missing something?

[spragueg]

1. Use the insect species name in each database to build a relationship.

2. Make a portal in database 1 that shows records from database 2 based on the species to species relationship (Please ask if you don't know what a portal is.)

3. Put fields you want to see from database 2 in the portal via the relationship.

Now when you search in database 1 any records that match the species name will automatically be visible in database 1.

[kelturner]

Thank you both for your input, I really appreciate it!

What I decided to do was to bring the info from database2 into database1.

I created a new layout specifically for all the extra insect biology data that can be opened from a button in the insect species search layout in database1. I then created a relationship between the two databases based on species name, and then opened database2 fields in database1 based on this relationship. It works great!

P.S. I had tried using copy in database1 and paste in database2, but the paste never really worked.