Quote Originally Posted by pdebaets View Post
First, don't name the field "FK: EquipmentId". "FK" means foreign key. Name the field "EquipmentID". Same for the other fields.

Next, there should be no EquipmentID foreign key on the People table.



This isn't the right query SQL. There's no phone number in the field list, but you've shown phone number in your sample results.
here's a SS of my relations windows.

Thanks again SOOOOOOOOOO much for your time. It is greatly appreciated!