98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Form linking tables
microsoft training access course - Form linking tables
Resolved · Low Priority · Version Standard
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
Fri 1 Dec 2006, 12:43Trainer Orok said...
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
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
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. |
Access tip:Using the Quick Access Toolbar in Access 2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |
