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 |
#11
|
|||
|
|||
data not flowing properly
On Fri, 27 Oct 2006 14:39:02 -0700, TechyTemp
wrote: Can a form and a subform be linked by more than one control? For instance, in my Order table there are two controls - sales order number and skids/parts number and the same two are part of the Order Detail subform. The two are related via the sales order number but I also need the skids/parts number control in the subform to be populated from the order table entry. Is that possible? Yes. The Master Link Field and the Child Link Field can consist of up to ten fieldnames (or control names from the main form for the Master), separated by semicolons. John W. Vinson[MVP] |
#12
|
|||
|
|||
data not flowing properly
How do I get to the link master/child fields? I have clicked on properties
for the form, the subform and the individual controls and don't see the options. "John Vinson" wrote: On Fri, 27 Oct 2006 14:39:02 -0700, TechyTemp wrote: Can a form and a subform be linked by more than one control? For instance, in my Order table there are two controls - sales order number and skids/parts number and the same two are part of the Order Detail subform. The two are related via the sales order number but I also need the skids/parts number control in the subform to be populated from the order table entry. Is that possible? Yes. The Master Link Field and the Child Link Field can consist of up to ten fieldnames (or control names from the main form for the Master), separated by semicolons. John W. Vinson[MVP] |
#13
|
|||
|
|||
data not flowing properly
Link Master/Child are properties of the subform control.
-- Duane Hookom MS Access MVP "TechyTemp" wrote in message ... How do I get to the link master/child fields? I have clicked on properties for the form, the subform and the individual controls and don't see the options. "John Vinson" wrote: On Fri, 27 Oct 2006 14:39:02 -0700, TechyTemp wrote: Can a form and a subform be linked by more than one control? For instance, in my Order table there are two controls - sales order number and skids/parts number and the same two are part of the Order Detail subform. The two are related via the sales order number but I also need the skids/parts number control in the subform to be populated from the order table entry. Is that possible? Yes. The Master Link Field and the Child Link Field can consist of up to ten fieldnames (or control names from the main form for the Master), separated by semicolons. John W. Vinson[MVP] |
#14
|
|||
|
|||
data not flowing properly
On Mon, 30 Oct 2006 08:08:02 -0800, TechyTemp
wrote: How do I get to the link master/child fields? I have clicked on properties for the form, the subform and the individual controls and don't see the options. The Subform Control is the "box" on the main form which contains the subform. That's what you need to select. To do so, click the *edge* of the subform in form design view, or use the dropdown list in the form design toolbar to select the subform control by name. John W. Vinson[MVP] |
#15
|
|||
|
|||
data not flowing properly
Thanks. I found it.
New question: I input data into the data input form but it didn't populate the table it was supposed to. I've been looking at these forms for several days. It's probably right in front of me but what should I check? "John Vinson" wrote: On Mon, 30 Oct 2006 08:08:02 -0800, TechyTemp wrote: How do I get to the link master/child fields? I have clicked on properties for the form, the subform and the individual controls and don't see the options. The Subform Control is the "box" on the main form which contains the subform. That's what you need to select. To do so, click the *edge* of the subform in form design view, or use the dropdown list in the form design toolbar to select the subform control by name. John W. Vinson[MVP] |
#16
|
|||
|
|||
data not flowing properly
Check the Record Source property of your form. If this is ok, check the
Control Source property of your bound controls. -- Duane Hookom MS Access MVP "TechyTemp" wrote in message ... Thanks. I found it. New question: I input data into the data input form but it didn't populate the table it was supposed to. I've been looking at these forms for several days. It's probably right in front of me but what should I check? "John Vinson" wrote: On Mon, 30 Oct 2006 08:08:02 -0800, TechyTemp wrote: How do I get to the link master/child fields? I have clicked on properties for the form, the subform and the individual controls and don't see the options. The Subform Control is the "box" on the main form which contains the subform. That's what you need to select. To do so, click the *edge* of the subform in form design view, or use the dropdown list in the form design toolbar to select the subform control by name. John W. Vinson[MVP] |
#17
|
|||
|
|||
data not flowing properly
I've discovered another glitch....I need for the sales order number to allow
duplicates even though it is a primary source in a couple of relationships. One sales order number may have part numbers for one account but several departments. These sales order numbers are assigned by a global system used by the entire company so there's no deviation from that. I can set up the relationship but I can't enforce referential integrity. I get a 'no unique index found' response. Is there anything I can do? "Duane Hookom" wrote: Check the Record Source property of your form. If this is ok, check the Control Source property of your bound controls. -- Duane Hookom MS Access MVP "TechyTemp" wrote in message ... Thanks. I found it. New question: I input data into the data input form but it didn't populate the table it was supposed to. I've been looking at these forms for several days. It's probably right in front of me but what should I check? "John Vinson" wrote: On Mon, 30 Oct 2006 08:08:02 -0800, TechyTemp wrote: How do I get to the link master/child fields? I have clicked on properties for the form, the subform and the individual controls and don't see the options. The Subform Control is the "box" on the main form which contains the subform. That's what you need to select. To do so, click the *edge* of the subform in form design view, or use the dropdown list in the form design toolbar to select the subform control by name. John W. Vinson[MVP] |
#18
|
|||
|
|||
data not flowing properly
I am now totally lost. It seems that your issue is no longer what it started
out as. You might need to start a new thread with complete specifications and significant information. -- Duane Hookom MS Access MVP "TechyTemp" wrote in message news I've discovered another glitch....I need for the sales order number to allow duplicates even though it is a primary source in a couple of relationships. One sales order number may have part numbers for one account but several departments. These sales order numbers are assigned by a global system used by the entire company so there's no deviation from that. I can set up the relationship but I can't enforce referential integrity. I get a 'no unique index found' response. Is there anything I can do? "Duane Hookom" wrote: Check the Record Source property of your form. If this is ok, check the Control Source property of your bound controls. -- Duane Hookom MS Access MVP "TechyTemp" wrote in message ... Thanks. I found it. New question: I input data into the data input form but it didn't populate the table it was supposed to. I've been looking at these forms for several days. It's probably right in front of me but what should I check? "John Vinson" wrote: On Mon, 30 Oct 2006 08:08:02 -0800, TechyTemp wrote: How do I get to the link master/child fields? I have clicked on properties for the form, the subform and the individual controls and don't see the options. The Subform Control is the "box" on the main form which contains the subform. That's what you need to select. To do so, click the *edge* of the subform in form design view, or use the dropdown list in the form design toolbar to select the subform control by name. John W. Vinson[MVP] |
#19
|
|||
|
|||
data not flowing properly
I have gotten most of my master and child links to work but I have one that
simply is not working. There are 3 master child links. The first two work just fine but the third link is not populating the child field and won't let me hand key it in either. What should I do? "John Vinson" wrote: On Fri, 27 Oct 2006 14:39:02 -0700, TechyTemp wrote: Can a form and a subform be linked by more than one control? For instance, in my Order table there are two controls - sales order number and skids/parts number and the same two are part of the Order Detail subform. The two are related via the sales order number but I also need the skids/parts number control in the subform to be populated from the order table entry. Is that possible? Yes. The Master Link Field and the Child Link Field can consist of up to ten fieldnames (or control names from the main form for the Master), separated by semicolons. John W. Vinson[MVP] |
|
Thread Tools | |
Display Modes | |
|
|