RMMcCluskey Posted January 22, 2008 Share Posted January 22, 2008 I'm stuck on this one and hope someone can help. I've got 3 tables, with the following fields: Lobbyists -LobbyistName Companies -CompanyName LobCompJoin -LobbyistName -CompanyName On my company layout, I want to have a portal that shows all records from LobCompJoin where the CompanyName matches the CompanyName in the Company table. Make sense? My problem is, my portal is showing all of the records from the LobCompJoin table, not just the records where the CompanyName matches. Any ideas on what I've screwed up? Here's my Relationships map... Link to comment Share on other sites More sharing options...
David Head Posted January 23, 2008 Share Posted January 23, 2008 You are using the wrong fields for the relationships. You should be using record IDs not data like company names and individual names. And totally redundant naming conventions! Why should all Individual fields start with 'Ind.'? Why do all table occurrence names start with 'Table.'? Link to comment Share on other sites More sharing options...
AHunter3 Posted January 23, 2008 Share Posted January 23, 2008 Indeed. You must not rely much on type-ahead. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts