Rob,
I looked for your old post and could not find it. Can you re-send it or
email me directly.
Thanks,
Scott
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Robert Brown
Sent: Tuesday, June 17, 2008 3:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Populate field from a Foreign Key (8.03.305L)
A common problem. Create a text box (invisible) and link it to JobNum.
Now trigger your subroutine based upon a change in that textbox value.
That always works. (I was incluced a code example in a previous reply to a
similar question a few weeks ago so unless you you delete everything in your
inbox, it is there.)
Rob Brown.
I looked for your old post and could not find it. Can you re-send it or
email me directly.
Thanks,
Scott
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Robert Brown
Sent: Tuesday, June 17, 2008 3:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Populate field from a Foreign Key (8.03.305L)
A common problem. Create a text box (invisible) and link it to JobNum.
Now trigger your subroutine based upon a change in that textbox value.
That always works. (I was incluced a code example in a previous reply to a
similar question a few weeks ago so unless you you delete everything in your
inbox, it is there.)
Rob Brown.
--- On Tue, 6/17/08, Scott Litzau <scott.litzau@...> wrote:
From: Scott Litzau <scott.litzau@...>
Subject: RE: [Vantage] Populate field from a Foreign Key (8.03.305L)
To: vantage@yahoogroups.com
Date: Tuesday, June 17, 2008, 1:54 PM
I am trying to do a simple AfterFieldChange Event with the JobHead Table and
JobNum field to make this occur. But nothing happens. So I tested a simple
MessageBox to make sure the AfterFieldChange Event was firing and nothing.
So then I used the table JobHeadList with a messagebox and that fired.
What the heck in the JobHeadList Table used for (obviously a Temp Table in
Job) and why wont a AfterFieldChange event not fire after a JobNum has been
entered in that field.
Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@ olympus-flag. com
P: 414-365-9732
F: 414-355-1931
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Kunal Ganguly
Sent: Tuesday, June 17, 2008 9:01 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Populate field from a Foriegn Key (8.03.305L)
If i understand correctly what you are trying to do, this can be done
programmatically like so:
' declarations
Private WithEvents edvJobHead as EpidataView
Private WithEvents edvOrderDtl as EpiDataView
edvJobHead = CType(oTrans. EpiDataViews( "JobHeadView" ), EpiDataView)
edvOrderDtl = CType(oTrans. EpiDataViews( "OrderDtlView" ), EpidataView)
' I am assuming the names "jobheadview" and "orderdtlview" , see data
tools in the customization for the actual view names
'somewhere appropriate in your code, depending on when and where you want
this done.
edvJobHead.dataView (edvJobHead. Row)("character0 1") =
edvOrderDtl. dataView( edvOrderDtl. Row)("character0 1")
Thanks,
Kunal
----- Original Message ----
From: Scott Litzau <scott.litzau@ olympus-flag. com>
To: vantage@yahoogroups .com
Sent: Tuesday, June 17, 2008 8:43:17 AM
Subject: [Vantage] Populate field from a Foriegn Key (8.03.305L)
In Job Entry I have created a Foriegn Key View and a Sub-Table View
from "Make to Order" to OrderHed to OrderDtl.
I placed a field on Job Entry and I want to populate it to
JobHead.Charater01 from OrderDtl.Character0 1. I know the key is working
because if I make the Data Source and Data Field OrderDtl.Character0 1 I
see the data from that in the text box I placed on the form. What I
want to do is make that text box on the form JobHead.Character01 and
have it be populated by OrderDtl.Charater01 so that the JobHead Table
holds this data.
How can I update JobHead.Charater01 from OrderDtl.Character0 1.
Thanks,
Scott
[Non-text portions of this message have been removed]
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links