|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 16th, 2010, 09:17 PM
posted to microsoft.public.access.forms
|
|||
|
|||
subform within subform On Main for Child master link question
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 
|
|
#2
March 17th, 2010, 04:46 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
subform within subform On Main for Child master link question
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
|
|
#3
March 17th, 2010, 06:55 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
subform within subform On Main for Child master link question
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
