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

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
> From: zjubias@gmail.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@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]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>

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