I'm trying to change the relational model of my database because they are improperly linked when I sync and no data is showing up- see attached proposed relationship. When I attempt to create a lookup I receive an error message- see attached.

Any help would be greatly appreciated. Thanks!!