Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Form linking tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft training access course - Form linking tables
Resolved · Low Priority · Version Standard
Reply Wed 29 Nov 2006, 16:53Delegate Jane said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Fri 1 Dec 2006, 13:48Delegate Jane said...
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
Reply Wed 6 Dec 2006, 09:37Delegate Jane said...
RE: Form linking tables
Sorry to clarify I am talking about forms. Main form as employee info and then for each employee to have a subform in a tab one tab showing project details and then the other showing the schedule for that project for the employee?
Reply Fri 15 Dec 2006, 14:25Delegate Jane said...
RE: Form linking tables
this is not resolved but don't worry i have ended up using a basic form option... thanks anyway