Trouble with table relationships
I have created a dummy database (FM Pro 10, Mac OS 10) with two tables: contacts and donations. The goal is to be able to show donations made over time per contact.
I've set this up so each contact gets a contact ID (Auto-enter serial, Can't modify auto). I've made relationships between the two tables. What's not working: The Contact ID is not showing up in the donations table, and the donations aren't showing up in the contacts table (donations data: amount, date, thank you letter sent-date). I've spent 3 weeks on this now, working from Coffey & Prossner and trying unsuccessfully to find answers in FM's Help database. Any ideas? Thanks in advance...