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
>
>
|
|
|
|