ACCESS FEED: RE: [MS_AccessPros] Form with a Tab-Form - How to link each Tab Record to the Record on MainForm

Senin, 03 Juni 2013

RE: [MS_AccessPros] Form with a Tab-Form - How to link each Tab Record to the Record on MainForm

Hello Duane,

Thank you for the feedback.

So, how do I breakdown my table, should I breakdown something like;

tblEmployee:

EmpRecNo (A/N)

EmpID

DeptID

SupervisorID

FName

LName

BOD

DateHired

Position

EmpNotes

tblAddress:

AddrRecNo (A/N)

EmpID (fk)

Country

Nationality

CountryPhone

EmergencyPhone

EmergencyContact

AddrNotes

tblWorkHistory:

WHRecNo (A/N)

EmpID (fk)

Company

Position

Year

WHNotes

tblDepartment:

DepRecNo (A/N)

DeptID

DeptName

DepNotes

tblSupervisor:

SprID (A/N)

SprFName

SprLName

SprNotes

tblDocuments:

DocRecNo (A/N)

DocID - (this will reset per employee)

EmpID

DocDescription

DocFrom

DocDate

DocCopy (scanned copy)

Thank you for feedback

zjubias

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Monday, June 03, 2013 11:04 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Form with a Tab-Form - How to link each Tab
Record to the Record on MainForm

zjubias,

This is basic Link Master/Link Child functionality of the subform control.
Set the properties to the appropriate fields and then sit back and enjoy.

Duane Hookom MVP
MS Access

----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> From: zjubias@gmail.com <mailto:zjubias%40gmail.com>
> Date: Mon, 3 Jun 2013 22:55:09 +0300
> Subject: [MS_AccessPros] Form with a Tab-Form - How to link each Tab
Record to the Record on MainForm
>
> Dear All,
>
>
>
> I was given a project to create an Employee Database to store personal
data,
> work history, document related to her/his employment (something like
warning
> memo, medical report, etc..
>
>
>
> Now, am conceptualizing how am going to present the employee record on one
> screen/form and it came to my mind to use a Tab Form, but a big question
pop
> up over, how could I establish a link between my main form having
> employeeid, department, supervisor as the main control in my main form.
How
> could I link each tab to make sure that all the records in each tab is
only
> related to the current employee shown on the main form..
>
>
>
> Can someone please show me how to do it.
>
>
>
> Thank you in advance,
>
>
>
> zjubias
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]