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

Selasa, 04 Juni 2013

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

Hello Sir Duane,

Thank you for your time.

Ok for tblAddress, I may not include this table anymore, since they want to
input only the employee's nationality and emergency contact(s). I may just
include these info into tblEmployee.

For tblSupervisor, how will I then link the supervisors to each employees.

For the documents, no, each document(s) were privately own by each
employee..

So assuming that my table structure is ok to go, how will I proceed to put
details on separate tab form and to link to each employee in the main form,
i.e.;

Is it something likely to use the empid as the link control to each tab
form?

Tab0 - employee info

Tab1 - employee work history

Tab2 - employee documents

Tab3 - employee emergency contacts

And may main form will be holding the general of employee, like: empid,
fname, lname, department & reportto.

Thank you in advance for your help,

zjubias

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Tuesday, June 04, 2013 8:11 AM
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

I'm confused by the purpose of the tblAddress since I don't see any fields I
would expect in the table.

Also, I would not create tblSupervisor but use tblEmployee for employees and
supervisors.

Can documents belong to more than one employee?

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: Tue, 4 Jun 2013 05:45:43 +0300
> Subject: 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%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > From: zjubias@gmail.com <mailto:zjubias%40gmail.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]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>

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

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