speakeasy
|
| Posted: 05/14/2001, 4:54 PM |
|
After reading the manuals, I am wondering, (and I am sure if possible) how
joins work.
Basically, lets say I have four tables.
Customer
Project
Quote
Lineitem
I have proper Key Fields in each to enable linking, with sql statments,
where the listing would be
project name
Then there migh be a few quotes
by customer,
a few line items listed.
Thats. it.
So I need an edit / new record screen, for the one project table, and and
edit - new screen for quotes. and
so on.
is there a good basis, for from the wizrds, or from the samples. I can get
an idea of what to look for ..
The connection, and the basis of codecharge I have running just fine. (but
only on one table so far)
Thanks.
Bob Lee
--
Bob
WWW.1AMSOFTWARE.COM
Bob@1amsoftware.com
In the beginning there was a command prompt and all was well.
|
|
|
 |
CodeCharge
|
| Posted: 05/14/2001, 7:32 PM |
|
Bob,
You may include fields from various tables in several ways:
a) If using MS Access, create a Query, which includes all the fields you
need, then use such query as the basis of your form, instead of single table
b) Click on the Form Properties and in the SQL tab, enter the SQL query that
includes joined tables as you like. This is similar to #a), except you are
using manually written SQL statement as the form basis, instead of the table
and this will work with many databases that don't support queries or views.
c) The "standard way" is to include single table on your form, then add the
fields that are linked to other tables and specify Join criteria in Field
Properties. You can access Field Properties by clicking on the properties
icon to the right of each field. Then you will see "JOIN" tab at the top,
where you can enter the information about the table that you like to join,
and which field from the linked table to include.
For example, the RegForm example includes list of Countries, Genders,
Incomes, etc. on the main Registration page. All those fields are using
Joins to display and select information from other tables.
Adam S.
CodeCharge Support
"speakeasy" <boblee@speakeasy.org> wrote in message
news:9dpr7m$1uj$1@mail.tankhill.com...
> After reading the manuals, I am wondering, (and I am sure if possible)
how
> joins work.
> Basically, lets say I have four tables.
> Customer
> Project
> Quote
> Lineitem
>
> I have proper Key Fields in each to enable linking, with sql statments,
> where the listing would be
> project name
>
> Then there migh be a few quotes
> by customer,
> a few line items listed.
>
> Thats. it.
>
> So I need an edit / new record screen, for the one project table, and and
> edit - new screen for quotes. and
> so on.
>
> is there a good basis, for from the wizrds, or from the samples. I can get
> an idea of what to look for ..
>
> The connection, and the basis of codecharge I have running just fine.
(but
> only on one table so far)
>
> Thanks.
> Bob Lee
>
>
> --
> Bob
>
> WWW.1AMSOFTWARE.COM
>Bob@1amsoftware.com
>
> In the beginning there was a command prompt and all was well.
>
>
>
|
|
|
|
|
