microsoft training access course - Form linking tables

Resolved · Low Priority · Version Standard

Wed 29 Nov 2006, 16:53 Delegate 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:43 Trainer 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:48 Delegate 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

Wed 6 Dec 2006, 09:37 Delegate 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?

Fri 15 Dec 2006, 14:25 Delegate 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips