L
linronamy
The following is a view of my database:
Table Relationships (which are questionably setup)
Liturgies(1) to LitEvents(many) and Cycles(1) to LitEvents(many)
Assign1() to LitEvents() and Assign2() to LitEvents()
There are 11 tables containing data each unique to one of 11 parts,
all having the same type link to the Assign tables,
5 to Assign1 and 6 to Assign2, each being (1) to the Assign(many)
Looks Like:
Legend: ()=Link w/o Referential Integrity, (1)=One, (M)=Many, (T)=Table
Litugies(T) LitEvent(T)
LitName
LitID(1) (M)LitID
Cycles(T)
CycleName
CyclesID(1) (M)CycleID
Assign1(T)
Assign2(T)
Assign1ID Assign2ID
LitEventID() ()LitEventID() ()LitEventID
PrepID(M) (1)PrepID
PrepHymn PrepHymn
PrepHymn# PrepHymn#
(above PREPs is example of
11 PARTs tables)
I have a main form with two subforms.
Main form linked to LitEvents Table
Subform linked to Assign1
Subform linked to Assign2
The Main form is data entry for defining the Liturgy and its Cycle.
The two subforms are data entry for the 11 parts(Hymn and Humn#).
Together the Main and both Subforms datas combine to define one record.
My problem is when I enter data into the 3 forms they are not linked as one
record.
I got here thru posting advice and am now very confused.
Any suggestions or questions appreciated.
Table Relationships (which are questionably setup)
Liturgies(1) to LitEvents(many) and Cycles(1) to LitEvents(many)
Assign1() to LitEvents() and Assign2() to LitEvents()
There are 11 tables containing data each unique to one of 11 parts,
all having the same type link to the Assign tables,
5 to Assign1 and 6 to Assign2, each being (1) to the Assign(many)
Looks Like:
Legend: ()=Link w/o Referential Integrity, (1)=One, (M)=Many, (T)=Table
Litugies(T) LitEvent(T)
LitName
LitID(1) (M)LitID
Cycles(T)
CycleName
CyclesID(1) (M)CycleID
Assign1(T)
Assign2(T)
Assign1ID Assign2ID
LitEventID() ()LitEventID() ()LitEventID
PrepID(M) (1)PrepID
PrepHymn PrepHymn
PrepHymn# PrepHymn#
(above PREPs is example of
11 PARTs tables)
I have a main form with two subforms.
Main form linked to LitEvents Table
Subform linked to Assign1
Subform linked to Assign2
The Main form is data entry for defining the Liturgy and its Cycle.
The two subforms are data entry for the 11 parts(Hymn and Humn#).
Together the Main and both Subforms datas combine to define one record.
My problem is when I enter data into the 3 forms they are not linked as one
record.
I got here thru posting advice and am now very confused.
Any suggestions or questions appreciated.