relational databases and lookups...confusion

[Dimwhit]

Does anyone know of a simple tutorial for relational databases and lookups? I'm still a novice with FileMaker, though I'm doing all right. But I'm trying to set up relational databases, and I'm hopelessly lost. I've read that section in the User's Guide three times and I'm missing something. I'm wondering if there's a step-by-step guide on doing this.

For reference, here is what I'm doing (and it's not very complex)

Database 1: A list of sponsors (name, address, phone, email, etc.). Simple. Like a contact list

Database 2: A list of events, containing date, description, donation amount, and sponsor name

I'm creating a layout in Database 2, and when I enter the sponsor name, I need to pull the related address and contact info from Database 1.

I know this should be easy, but going through the User's Guide doesn't help. I've learned the concept behind it, but I haven't been able to get it to work.

[John Caballero]

Hi there,

I just walked someone through this yesterday. They were setting up a movie rental database. Have a look here: http://www.fmforums.com/threads/showflat.php?Cat=&Number=91286&page=0&view=collapsed&sb=5&o=&fpart=1

Your situation is actually not as complicated as theirs because they are using three files (one for customers, one for movie titles/info, and one for the rental history).