Combining data to make report

[JeanPierre]

Hi,

Hope you can help me.

My problem;

I have a database with contracts. On those contracts work a lot of employees (1--15 per project)
Now i would like to make a report where the user can select the contract and the employee and combine those data.

The report that i then get is a contract with the specific data from the employee involved. I can then print it and have it signed by the employee !

Can you help me to combine the data from the contracts en employee data ?

Thank you very much!

Jean-Pierre Damme

 

[directrix]

7 hours ago, JeanPierre said:

Hi,

Hope you can help me.

My problem;

I have a database with contracts. On those contracts work a lot of employees (1--15 per project)
Now i would like to make a report where the user can select the contract and the employee and combine those data.

The report that i then get is a contract with the specific data from the employee involved. I can then print it and have it signed by the employee !

Can you help me to combine the data from the contracts en employee data ?

Thank you very much!

Jean-Pierre Damme

 

Hi there @JeanPierre,

 

Does your Employee and Contract data saved on different table? If it is, then you can create a View to join those table.

https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/

 

Hope that helps.

 

[NailDyanC]

Hi,

Just want to add from the previous comment above, you need to create first a relationship between the two tables before creating a view. You can check this link on how to do that: https://howto.caspio.com/tables-and-views/relationships/creating-and-managing-relationships/

Hope that helps.

Thanks,

@NailDyanC