A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

data not flowing properly



 
 
Thread Tools Display Modes
  #11  
Old October 28th, 2006, 12:00 AM posted to microsoft.public.access.tablesdbdesign
John Vinson
external usenet poster
 
Posts: 4,033
Default 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  
Old October 30th, 2006, 05:08 PM posted to microsoft.public.access.tablesdbdesign
TechyTemp
external usenet poster
 
Posts: 35
Default 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  
Old October 30th, 2006, 06:02 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 2,251
Default 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  
Old October 30th, 2006, 06:53 PM posted to microsoft.public.access.tablesdbdesign
John Vinson
external usenet poster
 
Posts: 4,033
Default 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  
Old October 30th, 2006, 10:36 PM posted to microsoft.public.access.tablesdbdesign
TechyTemp
external usenet poster
 
Posts: 35
Default 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  
Old October 30th, 2006, 11:26 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 2,251
Default 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  
Old November 1st, 2006, 05:38 PM posted to microsoft.public.access.tablesdbdesign
TechyTemp
external usenet poster
 
Posts: 35
Default 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  
Old November 1st, 2006, 06:31 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 2,251
Default 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  
Old November 13th, 2006, 05:21 PM posted to microsoft.public.access.tablesdbdesign
TechyTemp
external usenet poster
 
Posts: 35
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.