MYSQL QUERY HELP
Posted: 26 Nov 2020, 11:40
I am totally lost as to what the fields need in the MySQL Query (if this is even what I need to be using) so that I can return a field in one Entity into another entity.
I want to enter a client in the projects entity. I am using an Entity field with filters set to "client". I am getting what I want and I can select the client that this project is going to be done for. I also want to return the client's company name as frankly this is what I actually want to be "selectable" in the first place.
Can someone reply with the actual text I would type in each field in the MySQL Query set up fields? Or if I am totally not supposed to use this then how do I return the company name to the projects by milestone entity
Here is the dialog window
Here is the structure (note that I am working in Projects by milestone)
Here is the fields within the user Entity
And here is the fields in the Projects by milestone Entity
I want to enter a client in the projects entity. I am using an Entity field with filters set to "client". I am getting what I want and I can select the client that this project is going to be done for. I also want to return the client's company name as frankly this is what I actually want to be "selectable" in the first place.
Can someone reply with the actual text I would type in each field in the MySQL Query set up fields? Or if I am totally not supposed to use this then how do I return the company name to the projects by milestone entity
Here is the dialog window
Here is the structure (note that I am working in Projects by milestone)
Here is the fields within the user Entity
And here is the fields in the Projects by milestone Entity