I know I can do multiple links - master and child seperated by a semicolon
I have a the subform 2 that I need to link to subform 1 via WEEK Endate but
also Link Subform 2 to Main form via Man name - so not sure how to do THAT
The master child Link - I think only links from subform 2 to subform 1
(since Inside of 1 and not sure how to Link Subform 2 to Main form via
manname??? see below if need more clarification?
thanks for helping,
Barb
"KARL DEWEY" wrote:
> I am sure you can do multiple links.
> It has been a while but try these two things --
> Put the two field names separated by a comma or semicolon.
> Put the two field names concatenated using an ampersand ( & ).
>
> --
> Build a little, test a little.
>
>
> "babs" wrote:
>
> > I have a Main form with the following fields based on a table/query
> > Manname(know shouldn't be primary key) but only 42 employees that how it has
> > been for years
> > phone, position (so 42 records on Main form)
> >
> > subform 1 WeekEndDate ie. 3/14/2010,3/21/2010 weeks end on Sunday(so 52
> > Weeks)- for now the LInk child to Master(is set at ManName)-even though
> > manname not directly on This subform - thinking it is grabbing the link from
> > subform
> >
> > subform2 Inside subform 1 WeekEndDate(linked to subform1 child-master),
> > Workdate(so 6 days within one week that work)
> > Manname
> >
> > I think what I really want to do it link Manname from Subform2(which is
> > inside Subform 1 to ManName from Main form but not sure how to do that and
> > also Link WeekendDate from Subform 2 to Subform One.
> >
> > Overall summary trying to see EACH Manname on MainForm(42 employee)
> > subform 1 each new record is WEEKEND DATE
> >
> > When on Subform WeekEndDate for THAT WEEK - SEE THE 6 dAYS Schedule for THAT
> > given week for that given ManName only.
> >
> > What am I missing???
> > thanks,
> > barb
|
Similar Threads
