M
Mel
i create a query (qryAB) built on 2 tables... tblA and tblB
(tblB is a 'child" of tblA)
Now I use the form Wizard to build a Form on qryAB and elect to show
all the fields in qryAB on the form
The Wizzard ask me "How do you want to view your data?"
I click on tblB and the only option is "single form" so I take this
option.
Now my form doesn't display idA correctly... the 3 fields show like
this...
tblA_idA -- (note the underbar should show tblA.idA)
idB
tblB_idA -- (not ethe underbar should show tblB.idB)
so I have to go to design view, click in the fields and point them to
the correct data source.
Things seem to work after this.
Am I doing something wrong? Will forcing the fields to point to (what
I think are) the proper fields doing something that will get me in
trouble?
I'm just supprised the Wizard doesn't do this as I think it should and
wonder if I am mis-understanding something.
Thanks for any help.
Mel
(tblB is a 'child" of tblA)
From tblA the query has 1 fielsds... idA
From tblB the query has 2 fields... idA, idB
Now I use the form Wizard to build a Form on qryAB and elect to show
all the fields in qryAB on the form
The Wizzard ask me "How do you want to view your data?"
I click on tblB and the only option is "single form" so I take this
option.
Now my form doesn't display idA correctly... the 3 fields show like
this...
tblA_idA -- (note the underbar should show tblA.idA)
idB
tblB_idA -- (not ethe underbar should show tblB.idB)
so I have to go to design view, click in the fields and point them to
the correct data source.
Things seem to work after this.
Am I doing something wrong? Will forcing the fields to point to (what
I think are) the proper fields doing something that will get me in
trouble?
I'm just supprised the Wizard doesn't do this as I think it should and
wonder if I am mis-understanding something.
Thanks for any help.
Mel