Assistance with Many-To-Many relationship(s)
Hello all...I've read a number of articles on this and watched some videos and I thought I had it down but these something is not working quite correctly. Here's the gist of what I'm trying to do
I'd like to begin creating a CRM of sorts. Essentially the beginning would like like this.
Each "Account" could be assigned any number of "Employees" and similarly each "Employee" could be working on more than one "Account".
Each "Account" could have more than one "Contact" and of course each "Contact" could possibly be associated with more than one "Account"
I've attached my relationship here for your review. I've created two join tables that I think are configured correctly. Somehow my "join" tables are not populating AND as you can see from the preliminary Accounts layout each time I add an employee, I'm getting the same Employee ID (somehow).
Any advice on my relationship structure would be appreciated. Not sure if the problem is in the database structure or the prelininary layout. Ideally I'd like to be able to click on a button inside the portal that would automatically send me to the related employee on the employee layout
The Relationships look correct.
The portal shown should be a portal to Join Account Employees and your layout appears to be a layout based on Accounts. The Employee ID field should be from Join Account Employees and the other fields in the portal row would be from Employees.