Re: Repost - Open Form

Pam

There are a lot of folks who frequent these groups. Consider re-posting
(one more time) to get your question noticed by others. Just because I
couldn't understand doesn't mean someone else won't be able to help.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Pam" <pamnospam@xxxxxxxxxxxxxxxx> wrote in message
news:u2fXuRdAIHA.748@xxxxxxxxxxxxxxxxxxxxxxx
Jeff,

I appreciate your input. The tables and statements you listed are pretty
much how my database is set up. I don't understand your first question
when you ask about duplicating TechName in the work record. It's only
entered one time in the subform "fTTWorkLog" and is entered to the table
"tWorkLog". If you're thinking because they select their name in the
switchboard, this is an unbound combo box that gives a list of their jobs
assigned to them to select what they want to work on.

Again, I thank you for your time and effort, but I think I will leave well
enough alone. Undoubtedly, we aren't understanding each other. It was
just a little tweaking I wanted to do to try to eliminate human errors.

Pam


"Jeff Boyce" <nonsense@xxxxxxxxxxxx> wrote in message
news:eKXxdaVAIHA.4164@xxxxxxxxxxxxxxxxxxxxxxx
Pam

Why do you want to duplicate the TechName in the work record? A
mainform/subform construction would let Access put the Tech's ID in the
work record (think relational database).

Let's go back to the data. I still don't have a clear picture of what
data you have and how you've organized it.

Forget about how you now have the data structured for a moment. Think
about the real-world situation you're dealing with. Take a look at the
statements I'm guessing about below and let us know if they are
accurate...

One Tech can work on Many Jobs.

One Job can be worked on by Many Techs.

One Job can have Many WorkLog records.

One WorkLog record pertains to One and Only One Job.

If those statements fairly represent the world you are working in, then
one way to organize/normalize your data would be:

tblTechPerson
TechPersonID
FName
LName
DOB
... other person-specific info

tblJob
JobID
JobTitle
Description
DateOriginated
OriginatedBy
... other Job-specific info

trelPersonJobAssignment
PersonJobAssignmentID
TechPersonID
JobID
AssignmentDate
... other information specific to the assignment of one tech to one
job

trelWorkLog
WorkLogID
PersonJobAssignmentID
BeginDateTime
EndDateTime
ActivityDescription
... other information specific to what this person did on this job
(found by tracking back through trelPersonJobAssignment) during this time
interval

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"PHisaw" <PHisaw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:640EE078-8C18-44F9-AC85-827EDE919B5A@xxxxxxxxxxxxxxxx
Jeff,

Maybe I'm not explaining myself well enough for you to understand what
I'm
trying to do. At this point, I'm not even sure if it can be done or if
it's
worth the effort.

I have a table for Tech Names, a table for Jobs, and a WorkLog table
brings
them together. I wanted the subform that is on the main form to open
with
the name of the tech in the combo in the switchboard. The main form
that the
subform is on is linked to the subform by job number.

I already have everything in place and is working well. I just wanted
to
simplify things by having the subform open with name already entered.
Thanks,
Pam







.

Relevant Pages

  • Re: Repost - Open Form
    ... Why do you want to duplicate the TechName in the work record? ... work record (think relational database). ... One Tech can work on Many Jobs. ... I wanted the subform that is on the main form to open ...
    (microsoft.public.access.forms)
  • Re: Repost - Open Form
    ... One Tech can work on Many Jobs. ... One Job can have Many WorkLog records. ... PersonJobAssignmentID ... subform is on is linked to the subform by job number. ...
    (microsoft.public.access.forms)
  • Re: Repost - Open Form
    ... I have a table for Tech Names, a table for Jobs, and a WorkLog table brings ... subform is on is linked to the subform by job number. ... Unbound combo box "CboJobSelect" lists job numbers in db ... Form opens "fTTGeneralInfo" that lists info about job ...
    (microsoft.public.access.forms)
  • RE: Subform not allowing data entry - not your typical case?
    ... Could be some kind of further corruption that compact and repair does ... display the related customer information in the main form area. ... box also populates a SUBFORM which contains that customer's PROJECT ... main form) with that Project's related TECH ISSUE information (many tech ...
    (microsoft.public.access.forms)
  • Subform not allowing data entry - not your typical case?
    ... I have a sort of intricate form design which is giving me problems. ... display the related customer information in the main form area. ... box also populates a SUBFORM which contains that customer's PROJECT ... main form) with that Project's related TECH ISSUE information (many tech ...
    (microsoft.public.access.forms)
Loading