1 Topic by prahousefamily (edited by prahousefamily 2015-01-14 08:23:11)

  • Registered: 2014-02-17
  • Posts: 365

Topic: how to caculate from 2 table in table fileld type

how to edit  field  type (CALCULATED:)

drugitem.drug_cost_use * drugtransaction.sumunit

because after use edit expression editor error

show

no such table : fieldname

Post's attachments

Attachment icon 2015-01-14 Image 001.png 12.23 kb, 285 downloads since 2015-01-14 

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: how to caculate from 2 table in table fileld type

I made example for you.


Also you can send me your project to support@drive-software.com
or attach here zip file without exe and dll files

Post's attachments

Attachment icon Calculated field with two tables.zip 4.88 kb, 465 downloads since 2015-01-14 

Dmitry.
  • Registered: 2014-02-17
  • Posts: 365

Re: how to caculate from 2 table in table fileld type

How to edit  Expression

drugtransaction.drugsumprize

-drugtransaction.sumunit*drugitem.drug_cost_use
or
-select drugtransaction.sumunit*drugitem.drug_cost_use
from drugtransaction where  drugtransaction.id_drugitem =drugitem.id
or
???

help me please !
Check Drug Stock 2015.zip

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: how to caculate from 2 table in table fileld type

Please, check it

Post's attachments

Attachment icon Check Drug Stock 2015_2.zip 3.59 kb, 456 downloads since 2015-01-15 

Dmitry.
  • Registered: 2014-02-17
  • Posts: 365

Re: how to caculate from 2 table in table fileld type

Where to edit expression or table.ini ?
Have picture edit calcaulate ?

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: how to caculate from 2 table in table fileld type

Please, see an attach image for detail.

Post's attachments

Attachment icon calc.png 151.16 kb, 305 downloads since 2015-01-15 

Dmitry.
  • Registered: 2014-02-17
  • Posts: 365

Re: how to caculate from 2 table in table fileld type

Thank You Very More ..... Love love Love

My Visual Database : I Love You
Easy For Beginner Student For Me