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
|
|||
|
|||
main form to subform relationship
I thought that the main form data and it's subform data are all part of one
record, if so how do I configure the relationship to reflect that. When I enter data into the main form, go to the subform and enter data, shouldn't I be able to move to the next record and start over? |
#2
|
|||
|
|||
main form to subform relationship
I do not see a reason to have a subform if both main form and subform use the
same table. Many people use main-subform as parent-child relationship in a one-to-many relations. One order with many items in the order. The forms may use the same query as record source with the two tables joined in the query. "linronamy" wrote: I thought that the main form data and it's subform data are all part of one record, if so how do I configure the relationship to reflect that. When I enter data into the main form, go to the subform and enter data, shouldn't I be able to move to the next record and start over? |
#3
|
|||
|
|||
main form to subform relationship
On Tue, 14 Feb 2006 16:08:27 -0800, linronamy
wrote: I thought that the main form data and it's subform data are all part of one record, Typically, no, that is NOT the case. Instead, normally the Form would be based on the "One" side table, and the Subform on a related "many" side table. The records shown on the subform would be those associated with the currently selected record on the mainform, but it's a *different* table with *different* records. if so how do I configure the relationship to reflect that. When I enter data into the main form, go to the subform and enter data, shouldn't I be able to move to the next record and start over? Yes. If this isn't happening, and you're using tables with a defined relationship echoed in the Master/Child Link Field properties, please post the Recordsource properties of the two forms and the Master/Child Link Fields so we can see what might be wrong! John W. Vinson[MVP] |
#4
|
|||
|
|||
main form to subform relationship
This is an attempt to answer the Record Source Properties and Master/Child
Link Fields request in your post. I am a beginner!!!! RECORD SOURCE – MAIN FORM: LitEvents FIELDS: LitEventID, LitID, CycleID RELATIONSHIPS: LitID(Many) to LitID(1)of Liturgies Table CycleID(Many) to CycleID(1) of Cycles Table LitEventID to Assign1ID of Assignments1 Table and Assign2ID of Assignments2 Table RECORD SOURCE – ASSIGNMENTS1 SUBFORM: SELECT Assignments1.LitEvent1ID, Assignments1.Assign1ID, Assignments1.PrepID, Assignments1.PrepHymn, Assignments1.[PrepHymn#], Assignments1.PrComID, Assignments1.PrComHymn, Assignments1.[PrComHymn#], Assignments1.Com1ID, Assignments1.Com1Hymn, Assignments1.[Com1Hymn#], Assignments1.Com2ID, Assignments1.Com2Hymn, Assignments1.[Com2Hymn#], Assignments1.ClID, Assignments1.ClHymn, Assignments1.[ClHymn#], Assignments1.InPostID, Assignments1.InPostHymn, Assignments1.[InPostHymn#] FROM Assignments1; FIELDS: PrepID, PrepHymn, PrepHymn# PrComID, PrComHymn, PrComHymn# Com1ID, Com1Hymn, Com1Hymn# Com2ID, Com2Hymn, Com2Hymn# ClID, ClHymn, ClHymn# InPostID, InPostHymn, InPostHymn# RELATIONSHIPS: (typical) PrepID(Many) to PrepID(1) of Preparation Table Etc., etc….. RECORD SOURCE – ASSIGNMENTS2 SUBFORM: SELECT Assignments2.Assign2ID, Assignments2.LitEvent2ID, Assignments2.PrlID, Assignments2.PrlHymn, Assignments2.[PrlHymn#], Assignments2.InProcID, Assignments2.InProcHymn, Assignments2.[InProcHymn#], Assignments2.GathID, Assignments2.GathHymn, Assignments2.[GathHymn#], Assignments2.RPsID, Assignments2.RPsHymn, Assignments2.[RPsHymn#], Assignments2.GAID, Assignments2.GAHymn FIELDS: PrlID, PrlHymn, PrlHymn# InProcID, InProcHymn, InProcHymn# GathID, GathHymn, GathHymn# RPsID, RPsHymn, RPsHymn# GAID, GAHymn, GAHymn# RELATIONSHIPS: (typical) PrlID(Many) to PrlID(1) of Prelude Table The LitEvents MAIN FORM has 2 fields: LITURGIES and CYCLE The data fields in the two SUBFORMS relate to those two fields in the MAIN FORM, all making up a complete record. I hope this answers your request. Thanx for responding. "John Vinson" wrote: On Tue, 14 Feb 2006 16:08:27 -0800, linronamy wrote: I thought that the main form data and it's subform data are all part of one record, Typically, no, that is NOT the case. Instead, normally the Form would be based on the "One" side table, and the Subform on a related "many" side table. The records shown on the subform would be those associated with the currently selected record on the mainform, but it's a *different* table with *different* records. if so how do I configure the relationship to reflect that. When I enter data into the main form, go to the subform and enter data, shouldn't I be able to move to the next record and start over? Yes. If this isn't happening, and you're using tables with a defined relationship echoed in the Master/Child Link Field properties, please post the Recordsource properties of the two forms and the Master/Child Link Fields so we can see what might be wrong! John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Confussed as to which control to reference subform | melwester | Using Forms | 5 | June 30th, 2005 06:49 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
open a form through a subform in access 2000 | Tammy | Setting Up & Running Reports | 12 | October 22nd, 2004 02:43 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Filter subform combobox on option button in main form | Emma | Using Forms | 1 | June 12th, 2004 12:24 AM |