S
Steve
I have a Periodical (magazine) database with need of four MotherChild
relationships
TblPeriodicalBasics has fields for title abbreviation, month,volume,number,
year and a field called PeriodicalUniqueCode which uses an updateQuery to
create e.g. FP Apr 2002 using Iif statement.
How do I get this to run please without running the query myself, perhaps
run it as soon as click on another field window, just what is the coding
please ?
TblPeriodicalBasics relates to TblPeriodicalContents on field IDperiodical
TblPeriodicalContents relates to TblArticlePhotoContents (OneToMany
situation) on field PhotoUniqueCode (Uses UpdateQuery to combine
PeriodicalUniqueCode with PAGE NUMBER and PositionOnPageAbbv to create a
PhotoUniqueCode)
I have FrmPeriodicalContents as a subform in FrmPeriodicalBasics, any data
entry sees it enter IDperiodical also into its own field of that name, GOOD
!.
My problem is I also need to have it do this for field PeriodicalUniqueCode
as the next subform FrmArticlePhotoDetails uses this as its relational link.
Just how do I get it to bring across that fields data only for the record
being entered. Or is this bad design, should I instead link them on
perhaps IDperiodicalContents. And the next subform FrmEmblems (looking at
insignia per aircraft visible in one photo so again a OneToMany) would be
linked on IDArticlePhotoDetails in that case.
If I adopt the ID linking instead of UniqueCodeLinking, I would still need
to bring into the form and its assoc table the data for the field being used
as the link though, so how do I do this ?
I would like to see the magazine ident FP Apr 2002 brought into each subform
as a reminder what mag I am on, but not as stored data, how is this done,
(if its codes please write actual codes if poss as makes more sense to me !)
Steve
relationships
TblPeriodicalBasics has fields for title abbreviation, month,volume,number,
year and a field called PeriodicalUniqueCode which uses an updateQuery to
create e.g. FP Apr 2002 using Iif statement.
How do I get this to run please without running the query myself, perhaps
run it as soon as click on another field window, just what is the coding
please ?
TblPeriodicalBasics relates to TblPeriodicalContents on field IDperiodical
TblPeriodicalContents relates to TblArticlePhotoContents (OneToMany
situation) on field PhotoUniqueCode (Uses UpdateQuery to combine
PeriodicalUniqueCode with PAGE NUMBER and PositionOnPageAbbv to create a
PhotoUniqueCode)
I have FrmPeriodicalContents as a subform in FrmPeriodicalBasics, any data
entry sees it enter IDperiodical also into its own field of that name, GOOD
!.
My problem is I also need to have it do this for field PeriodicalUniqueCode
as the next subform FrmArticlePhotoDetails uses this as its relational link.
Just how do I get it to bring across that fields data only for the record
being entered. Or is this bad design, should I instead link them on
perhaps IDperiodicalContents. And the next subform FrmEmblems (looking at
insignia per aircraft visible in one photo so again a OneToMany) would be
linked on IDArticlePhotoDetails in that case.
If I adopt the ID linking instead of UniqueCodeLinking, I would still need
to bring into the form and its assoc table the data for the field being used
as the link though, so how do I do this ?
I would like to see the magazine ident FP Apr 2002 brought into each subform
as a reminder what mag I am on, but not as stored data, how is this done,
(if its codes please write actual codes if poss as makes more sense to me !)
Steve