Forum Discussion
Multiple date columns in different tables
So you need to create a proper Calendar (Date) table and connect your Hours,Expenses,Invoices tables to it via Date field.
Here is an example how your model will look like:
Matrix:
Date from Calendar table in columns, Project from Project table, Hours amt from Hours table, Expenses amt from Expenses table.
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
Hi Daimy ,
Do I understand correctly that your Hours,Expenses,Invoices tables contain a date field and they are connected to your Project table via some ProjectID/Project name field?
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
ERD Correct. All three tables have in common that they are linked to Project via ProjectID field. All three tables have a selling amount and a date field.
So you need to create a proper Calendar (Date) table and connect your Hours,Expenses,Invoices tables to it via Date field.
Here is an example how your model will look like:
Matrix:
Date from Calendar table in columns, Project from Project table, Hours amt from Hours table, Expenses amt from Expenses table.
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.