Member Avatar for Nebil

Hi,

I had a little problem in querying something. When defining a project you use work items. And a work item may use a material, labor and equipment. It may not use one or two of them for that work item when it is defined.

So for that work item you will define a performance rate, just a value given for that work item in the defined project, it varies project from project.

So when i want to define a performance rate i want to query all the work items used in that project from the three tables,remember that i may or may not use the above items for that work item under that defined project.

How can i achieve that?

1.png 63.32 KB
  • 2 Contributors
  • 1 Reply
  • 125 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by Santanu.Das
Member Avatar for Santanu.Das

How far did you do? Post your codes for querry.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.