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...
The appropriate design for this is a main form with a subform in it.
The main form can be bound to either the Project table or the employee table, but I would expect it to be more useful to bind it to the Project table.
The subform is bound to the Work table. The ID and ProjID fields in the subform do not need to be displayed, but do need to be in the subform. The employeeID in the subform is selected with a combo box and the other fields are entered as appropriate.
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.
- 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.- My suggestion is that you use the main form/sub form design approach instead.
