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

 2 or more tables in one form

Print topic Send  topic

Author Message
Heictor Hsiao
Posted: 02/04/2001, 1:06 AM

Hi there

I had some problem when I try to use 2 or more data table to show in one
form (not separate forms in one page), this program seems not support it
without coding, am I right?

Heictor

guest
Posted: 02/04/2001, 5:08 AM

Hello Heictor,

You wrote
> I had some problem when I try to use 2 or more data table to show in one
> form (not separate forms in one page), this program seems not support it
> without coding, am I right?
Yes , you are right, for the time being it's not possible yet to have 2
data tables in one form
without manual coding. Why don't you add another form with another table?

Regards,
Alexey
CodeCharge Support



guest
Posted: 02/04/2001, 5:08 AM

Hello Heictor

Yes , one data table per one form

Regards,
Alexey
CodeCharge Support

> I had some problem when I try to use 2 or more data table to show in one
> form (not separate forms in one page), this program seems not support it
> without coding, am I right?
>


Heictor Hsiao
Posted: 02/05/2001, 10:32 PM

Thanx Alexey

The reason I need to do so is :

table one ------> footwear
footwear_ID
footwear_name
..........

table two ------->
SN ---->PK
footwear_ID
footwear_category

in my case I need to design a form for showing the footwear information
form fields
Footwear name
Footwear category

the reason I seperate the footwear table to two table is because every
footwear
has more than one category, and the category can't be for exsample
FootWear_ABC = category1, category3, category4
FootWear_BCD = category3, category4

I am thinking if there's any better way to write this form without coding by
CC.
cause I am not a programer but a planner, and I found CC can help me in a
lot work.


Heictor Hsiao
>
> Yes , one data table per one form
>
> Regards,
> Alexey
> CodeCharge Support
>
> > I had some problem when I try to use 2 or more data table to show in
one
> > form (not separate forms in one page), this program seems not support it
> > without coding, am I right?
> >
>
>
>

Joachim Uersfeld
Posted: 02/06/2001, 1:42 AM

Create a view with a join between the two tables. CC can handle a view like
one table.

Joachim
Mainz/Germany


"Heictor Hsiao" <heictor.cona@msa.hinet.net> schrieb im Newsbeitrag
news:95o5pk$k0m$1@news.codecharge.com...
> Thanx Alexey
>
> The reason I need to do so is :
>
> table one ------> footwear
> footwear_ID
> footwear_name
> .........
>
> table two ------->
> SN ---->PK
> footwear_ID
> footwear_category
>
> in my case I need to design a form for showing the footwear information
> form fields
> Footwear name
> Footwear category
>
> the reason I seperate the footwear table to two table is because every
> footwear
> has more than one category, and the category can't be for exsample
> FootWear_ABC = category1, category3, category4
> FootWear_BCD = category3, category4
>
> I am thinking if there's any better way to write this form without coding
by
> CC.
> cause I am not a programer but a planner, and I found CC can help me in a
> lot work.
>
>
> Heictor Hsiao
> >
> > Yes , one data table per one form
> >
> > Regards,
> > Alexey
> > CodeCharge Support
> >
> > > I had some problem when I try to use 2 or more data table to show in
> one
> > > form (not separate forms in one page), this program seems not support
it
> > > without coding, am I right?
> > >
> >
> >
> >
>
>

Paul
Posted: 02/06/2001, 11:49 AM

If I could jump in here. I two require two tables in one report table. I
develop intranet applications for our company and do a lot of reports that
require this. For an example:

Transportation Schedule which takes the rider's name and address from one
table based on the clientID, and the date, time, destination, and
transportation provider from another. This all goes into a single table
row. We generate a report for morning and another for afternoon for each day
and then print them off.

So you see it is really important that tables be able to be joined.

Paul
Alexey Alexapolsky wrote in message <95jk7e$igp$1@news.codecharge.com>...
>Hello Heictor,
>
>You wrote
>> I had some problem when I try to use 2 or more data table to show in
one
>> form (not separate forms in one page), this program seems not support it
>> without coding, am I right?
>Yes , you are right, for the time being it's not possible yet to have 2
>data tables in one form
>without manual coding. Why don't you add another form with another table?
>
>Regards,
>Alexey
>CodeCharge Support
>
>
>
>

Paul
Posted: 02/06/2001, 11:52 AM

Could you please explain what you mean by "create a view" I'm not sure I
understand what that is; and I really need this ability also.

Thank you;

Paul
Joachim Uersfeld wrote in message <95ogu8$8l1$1@news.codecharge.com>...
>Create a view with a join between the two tables. CC can handle a view like
>one table.
>
>Joachim
>Mainz/Germany
>
>
>"Heictor Hsiao" <heictor.cona@msa.hinet.net> schrieb im Newsbeitrag
>news:95o5pk$k0m$1@news.codecharge.com...
>> Thanx Alexey
>>
>> The reason I need to do so is :
>>
>> table one ------> footwear
>> footwear_ID
>> footwear_name
>> .........
>>
>> table two ------->
>> SN ---->PK
>> footwear_ID
>> footwear_category
>>
>> in my case I need to design a form for showing the footwear information
>> form fields
>> Footwear name
>> Footwear category
>>
>> the reason I seperate the footwear table to two table is because every
>> footwear
>> has more than one category, and the category can't be for exsample
>> FootWear_ABC = category1, category3, category4
>> FootWear_BCD = category3, category4
>>
>> I am thinking if there's any better way to write this form without coding
>by
>> CC.
>> cause I am not a programer but a planner, and I found CC can help me in a
>> lot work.
>>
>>
>> Heictor Hsiao
>> >
>> > Yes , one data table per one form
>> >
>> > Regards,
>> > Alexey
>> > CodeCharge Support
>> >
>> > > I had some problem when I try to use 2 or more data table to show
in
>> one
>> > > form (not separate forms in one page), this program seems not support
>it
>> > > without coding, am I right?
>> > >
>> >
>> >
>> >
>>
>>
>
>

Joachim Uersfeld
Posted: 02/06/2001, 2:03 PM

Hi Paul,

on the most SQL Server you can create a tempory table that contains fields
of two or more tables.

CRATE VIEW myViey
AS
SELECT table1.Field1,
table2.Field2
FROM table1,
table2
WHERE table1.table1ID = table2.Table2ID

CodeCharge show this View with the tablenames, handle it as one table.

CodeCharge has an another great Solution. There is under FieldProperties the
page Join. Here can you bind a ID to another table. CC generates automatic
the code to show the join.

I hope this helps, and you understand my bad englisch.

Regards,

Joachim
Mainz/Germany



"Paul" <paporter@visto.com> schrieb im Newsbeitrag
news:95pkmm$uls$1@news.codecharge.com...
> Could you please explain what you mean by "create a view" I'm not sure I
> understand what that is; and I really need this ability also.
>
> Thank you;
>
> Paul
> Joachim Uersfeld wrote in message <95ogu8$8l1$1@news.codecharge.com>...
> >Create a view with a join between the two tables. CC can handle a view
like
> >one table.
> >
> >Joachim
> >Mainz/Germany


Paul
Posted: 02/06/2001, 3:02 PM

Thank you Joachim. I'll give that a try. I really do appreciate your help.

Paul
"Joachim Uersfeld" <uersfeld@pc-team.de> wrote in message
news:95psbn$cr6$1@news.codecharge.com...
> Hi Paul,
>
> on the most SQL Server you can create a tempory table that contains fields
> of two or more tables.
Snipp........

Heictor Hsiao
Posted: 02/06/2001, 5:18 PM

That's such a good idea, but this way is one way only, because we can not
use one SQL command to write both 2 tables which include in the view.

Heictor Hsiao


> Create a view with a join between the two tables. CC can handle a view
like
> one table.
>
> Joachim
> Mainz/Germany
>
>
> "Heictor Hsiao" <heictor.cona@msa.hinet.net> schrieb im Newsbeitrag
>news:95o5pk$k0m$1@news.codecharge.com...
> > Thanx Alexey
> >
> > The reason I need to do so is :
> >
> > table one ------> footwear
> > footwear_ID
> > footwear_name
> > .........
> >
> > table two ------->
> > SN ---->PK
> > footwear_ID
> > footwear_category
> >
> > in my case I need to design a form for showing the footwear information
> > form fields
> > Footwear name
> > Footwear category
> >
> > the reason I seperate the footwear table to two table is because every
> > footwear
> > has more than one category, and the category can't be for exsample
> > FootWear_ABC = category1, category3, category4
> > FootWear_BCD = category3, category4
> >
> > I am thinking if there's any better way to write this form without
coding
> by
> > CC.
> > cause I am not a programer but a planner, and I found CC can help me in
a
> > lot work.
> >
> >
> > Heictor Hsiao
> > >
> > > Yes , one data table per one form
> > >
> > > Regards,
> > > Alexey
> > > CodeCharge Support
> > >
> > > > I had some problem when I try to use 2 or more data table to show
in
> > one
> > > > form (not separate forms in one page), this program seems not
support
> it
> > > > without coding, am I right?
> > > >
> > >
> > >
> > >
> >
> >
>
>

guest
Posted: 02/07/2001, 3:03 AM

Hello Heictor,

You could use information from a few tables in one form this way:
Now that you want to add fields from other tables , add a new field
with "Label" type , click on properties icon of the left. Select
"Join"
tab , select "table" - this is the table containing foreign fields,
"Primary key" is the key that will be used to join these tables ,
"Showing" will be the field you want to get from the second table.
That's it.


Regards,
Alexey
CodeCharge Support


CodeCharge
Posted: 02/07/2001, 3:04 AM

Here is hopefully a more complete and accurate answer:
There are actually 3 ways of doing this:
- Specify an SQL statement into SQL section of Form Properties
- Use a View or Query instead of the Table (for example CC allows you to use
MS Access query)
- Specify 2nd table in "Join" section of Field Properties


Heictor Hsiao <heictor.cona@msa.hinet.net> wrote in message
news:95j638$ntq$1@news.codecharge.com...
> Hi there
>
> I had some problem when I try to use 2 or more data table to show in one
> form (not separate forms in one page), this program seems not support it
> without coding, am I right?
>
> Heictor
>
>


   


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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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