Help with relationships on call log
Let me start by apologizing for my noobness, I recently purchased FMP 11 and the FileMaker Pro 11 The Missing Manual book and am rather new at databases and how they function. Nonetheless, I've managed to set up a database with two tables in it and would say I've gotten past the beginner level and moved onto creating relationships, key fields and portals - though I barely understand what it is that I'm doing. That being said, here's what I'm trying to do and what I woudl appreciate some help on.
Basically, I run my boss's call log and use it to roll calls. I have simple text fields in this order:
DATE, TIME, STATUS, CALLER, NUMBER, NOTES
When I get a call in, I'd like to be able to enter the caller name and have the phone number for that person auto-fill for me, rather than me have to search and find the number and copy/paste it into the number entry. It seems like such a simple action that I'm sure I'm missing some simple step here. I'm willing to rebuild the database from the getgo in order to make this work.
I tried making two tables and creating a relationship for them, I tried linking keyfields on both tables and had no luck. I feel totally lost in a foreign country with foreign language directions. Would anybody be able to help me?
Thanks in advance!