I have a friend using FMP 5.5 on a Windows XP machine. He currently
has two seperate databases; one for books and one for publishers. And
he wants to have a way of importing the publisher's information (name,
address, etc) into the book database for one of its layouts. I said
that wrong; he does have a way now. He uses a relationship based
between a book serial number field and the publisher serial number
field. He has a field in the Books database where he can place in the
serial number from the Publisher database and the info is then placed
in the Books database. This is all done by hand: 1) look up publisher
in the book, 2) find the Publisher in the Publisher database, 3) write
down that serial number (or memorize it), 4) go to the Books database
and find that book's record and then enter the serial number from step
3.
He wants to know if there is a simpler method. Like clicking a
button to do a script or do something with a portal to find the
"Publisher" from the Publisher database and place the serial number in
the correct field in the Books database. Or is it just flipping back
and forth between the two databases?
I tried to help by digging into the FMP manual, but it's very short
section on relationships demonstrates the exact same method that he is
using. I tried to Google it, and must not be using the right key words
because I have found nothing. Does anyone know of a book or magazine
article or something? Maybe a similar setup between two files so that
I can "clone" or copy what is done and have his do that?
|
