StuartA
|
| Posted: 08/27/2004, 3:48 AM |
|
I'm considering using CCS as my RAD and had a question. The product I'm using currently can't do this.
First, this isn't necessarily a many to many situation , though it can be.
Let me explain.
I have a table called Member Titles
Members are allowed (or will be) to choose up to 5 titles.
They are all stored in the Member Titles table along with their associated "memberID"
Right now I'm limited to how many transaction's I can have on one page. Unless of course I want to do a good deal of hand coding (trying to avoid )
While I could break it into a m2m, I'd increase my tables to MemberTitles1, MemberTitles2, MemberTitles3, etc. Aside from the joins, the impositions on queries is what would not be pretty.
So , what I'm trying to find out here is multiple insertions into one table from one form possible with CCS ?
Thank you,
Stuart
|
|
|
 |
E43509
Posts: 283
|
| Posted: 08/27/2004, 6:05 AM |
|
Yes, you can use the editable grid to insert multiple insert lines
You set the number you want.
|
 |
|
Don Safar
|
| Posted: 08/27/2004, 8:51 AM |
|
In the CCS example pack see the one titled "Updating Many-to-Many Relations
via CheckBox List".
"StuartA" <StuartA@forum.codecharge> wrote in message
news:2412f1170716c6@news.codecharge.com...
> I'm considering using CCS as my RAD and had a question. The product I'm
using
> currently can't do this.
>
> First, this isn't necessarily a many to many situation , though it can be.
> Let me explain.
>
> I have a table called Member Titles
>
> Members are allowed (or will be) to choose up to 5 titles.
> They are all stored in the Member Titles table along with their associated
> "memberID"
>
> Right now I'm limited to how many transaction's I can have on one page.
Unless
> of course I want to do a good deal of hand coding (trying to avoid )
>
> While I could break it into a m2m, I'd increase my tables to
MemberTitles1,
> MemberTitles2, MemberTitles3, etc. Aside from the joins, the impositions
on
> queries is what would not be pretty.
>
> So , what I'm trying to find out here is multiple insertions into one
table
> from one form possible with CCS ?
>
> Thank you,
> Stuart
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
StuartA
|
| Posted: 08/27/2004, 11:01 AM |
|
The example was good. But if I don't want to do a many to many , it looks like I can still accomplish multiple insertions into 1 table.
Thank you
Stuart
|
|
|
|
|
