CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Foreign Key Field when inserting records

Print topic Send  topic

Author Message
Juan
Posted: 02/19/2001, 5:05 AM

Hi,

How can I show foreign keys with code charger?
For example: I have two tables Project and Party. Project has a field
IdParty that points to Party.
When I will insert a new record I would like to show all parties in a
combobox.

Does CodeCharge do this?

TIA,
Juan

Alexey Alexapolsky
Posted: 02/19/2001, 6:30 AM

Hmm.. it's definitely possible.
By the way , there's no standard way to make combo boxes in html.
But actually for this task listbox will suffice . With "multiple" property
perhaps.
Actually I need more details.

Add new Form
Select party table.
Add field of listbox type.
In a few words , you set in "Form properties" , Input tab , some input
variable "project_id"
and now all fields on this form will correspond to a project with this id.
See example provided with CodeCharge , BookStore example. There is
everything.


--
Regards,
Alexey
CodeCharge Support


> How can I show foreign keys with code charger?
> For example: I have two tables Project and Party. Project has a field
> IdParty that points to Party.
> When I will insert a new record I would like to show all parties in a
> combobox.
>
> Does CodeCharge do this?
>
> TIA,
> Juan
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.