AnsweredAssumed Answered

SQL without relations

Question asked by heinrichh on Mar 7, 2018
Latest reply on Mar 9, 2018 by beverly

Hi,

 

I want to get values via SQL from a table, that includes some value for the employess.

Here's an example , what I am exactly mean:

Relation: Employee <-> Commission <-> Sales_Success

Request:

By typing a value on the Employee-Layout, the user should see the graduation of the employee. The graduation should be defined in the table 'sales_success' depending on the typed value for "sold_contracts".

 

The table 'sales_success' contains the ranges for defining the grads of the employee.

 

E.g.

>10 = 'standard'

>20 = 'Gold'

>30 = 'Premium"

 

So far, so good, but, if I enter the value in the field 'sold_contracts' (e.g. 12), and put that value as a parameter into my SQL-Query, in expectation to get the graduation 'Gold' and show that on the layout "emplyee", the query gives the errormsg <Table has no relation>.

 

With SQL it should be not necassary to make a relation, or have I misunderstood something?.

 

Thanks in advance

 

Heinrich

Outcomes