Jane has attended:
No courses
Form linking tables
I have 3 tables set up: employees; projects and my joining table is scheduling. I would like to create an employees form with a tab subform: page 1 projects; page 2 tabular scheduling.So essentially I would like for each employee the tab sub report to show the project they working on with the details and then on the second tab to show their schedule which is allocated days per month.
I have created a query linking the 3 tables but am unable to get them talking to each other properly. I have tried various options. the tab form I have created works properly with eachother but if I insert it as a subform into an employees form, they don't talk to each other. I am just not sure what link I need to setup.
many thanks
Jane
RE: Form linking tables
Hi Jane,
The steps you describe sound correct.
I would suggest you ensure your join properties are set to Include ALL records from 'Scheduling' and only those records from 'Employes' where the joined fields are equal and also Include ALL records from 'Scheduling ' and only those records from 'Projects' where the joined fields are equal.
Regrds
RE: Form linking tables
That is the join type I have set up and it doesn't work? I want my main report to be by employee. so the main record selector to only be that of employees +/- 20. Then the subreports to show the information relating to each project they work on and then a tabular form showing the days per month allocated to each project? Any more advice? Thanks
