Don_S
Posts: 50
|
| Posted: 05/31/2005, 1:00 PM |
|
Ok, here is what I need to do. Normally when you set up a new record you have a table with two columns, lefthand column is your field name, righthand column in your textbox or whatever for data input. What I need is to have the lefthand column show data from an other table. Example:
Table A:
Name1
Name2
Name3
Table B:
Input1
Input2
Onput3
Record builder based off Table B:
Field Name Field
Name1 Input1
Name2 Input2
Name3 Input3
I hope that is sort of clear... Anyways when I tried to put labels in the column all I got were blank spaces when viewed.
Anyone have a solution?
Thanks,
Don
|
 |
 |
Nicole
Posts: 586
|
| Posted: 06/01/2005, 4:43 AM |
|
Don,
As data source for your record form use a table which you want to update. To use data from other table as field names you can put Labels and create Before Show event for a form where look up necessary values from the second table and assign those values to Label controls.
Help article would be useful in completing it
http://docs.codecharge.com/studio/html/index.html?http:...BValue.html?toc
http://docs.codecharge.com/studio/html/ProgrammingTechn...Values.html?toc
_________________
Regards,
Nicole |
|
|
|
Don_S
Posts: 50
|
| Posted: 06/01/2005, 8:49 AM |
|
Hi Nicole,
Should I put to the lookup in the Before Show of the page or the form. I tried entering the code below into the Before Show of the page but I am getting a syntax error...
Function Page_BeforeShow() 'Page_BeforeShow @1-653D685B
'Custom Code @77-73254650
' -------------------------
Page.Cust1.Value = CCDLookUp(Cust1,tbl_Custom,Cust_ID= & DBConnection1.ToSQL(CCGetParam(Cust_ID,0),ccsInteger), DBConnection1)
' -------------------------
'End Custom Code
End Function 'Close Page_BeforeShow @1-54C34B28
Where did I go wrong?
Thanks for all your help,
Don
P.S. I see you answering a lot of posts here at the Forum. I don't know what a lot of users would do without your help. It's people like you that make forums like this work so well. Thank you!
|
|
|
|
Nicole
Posts: 586
|
| Posted: 06/02/2005, 3:08 AM |
|
Don,
Put the code to Before Show event of a form.
Also parameter name in CCGetParam() function should be surrounded with double quotes
CCGetParam("Cust_ID", 0)
http://docs.codecharge.com/studio/html/Components/Funct...tParam.html?toc
_________________
Regards,
Nicole |
|
|
|
|
