Forum Discussion
show data from two tables with some calculation in a from
Hello guys, I am trying to build a small database for my business, I have 3 tables: Projects: - ProjID - ProjName Employees: - EmpID - EmpName - EmpRate Work: -ID -ProjID -EmpID...
thank George for your quick answer, what is your suggestion regarding this:
The design you sketched out, with both the employeeID and ProjectID on the main form won't work out in practice due to the relationships between the tables.
The design you sketched out, with both the employeeID and ProjectID on the main form won't work out in practice due to the relationships between the tables.
My suggestion is that you use the main form/sub form design approach instead.