subform within subform On Main for Child master link question

  • Thread starter Thread starter babs
  • Start date Start date
B

babs

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
 
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 ( & ).
 
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
 
Back
Top