relationships/lookups

[hank101]

Hi folks,

I need some guidance here, I have two databases from FM3, I'm now hosting them on FM9. One database is basically an Author contact information database, the other is a database that has books stories etc from those authors, I'd like to combine them into one database. I could do this by importing the tables right?

And when adding a new entry in the story database, only have to enter, say the Authors name and have the rest of the contact info auto-fill. Is this possible?

thanks

Hank

Edited June 10, 2008 by Guest

[Fitch]

You can import the tables, yes. You can't import relationships, though; you'll have to recreate them.

You can auto-enter related data using calculations or lookups, or you can simply display the related data (I would think a better option here). However, you really should use a unique ID (auto-entered serial number is an excellent choice) rather than a field that can be modified.

[LLX]

strt thinking with Portals. and use a portal to display theastories data tied to the author info

[Fitch]

In this case a portal may not be necessary. I.e., if the goal is to show the author info on a story layout, and there's only one author, you can show the related fields directly, no need for a portal.

If some items have multiple authors, that's a different story. :)