microsoft training access course - form linking tables

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version Standard

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

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?

RE: Form linking tables

this is not resolved but don't worry i have ended up using a basic form option... thanks anyway


 

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


Server loaded in 0.1 secs.