calculated field with a sql query dependent on the value of another field

7 years ago

Topic

I have a content type "services" with these fields:
id, service, value

I have to build another content type: "purchases" with these fields:
id
service_id (select dynamic on content type services)
quantity
total ---> here is the problem: how to select "value" through service_id and multiply it with quantity?