Copying multiple fields into the next blank field(s) 
Author Message
 Copying multiple fields into the next blank field(s)

I can do this with the If statement and IsEmpty but can only loop
twice (to the first row if it's empty and the 2nd if the first is not
empty). I have 75 rows with 3fields in each row, Name, Cost & MF. I'd
like the user to be able to chose a row and copy all three fields into a
blank rows (There are 4 blank rows-Name1, Cost1 & MF1; Name2, Cost2, &
MF2; Name3, Cost3 & MF3; Name4, Cost4, MF4). The script reads as
follows:
Loop
Copy [Name]
If[IsEmpty(Name1)]
Paste [Name1]
Copy [Cost]
Paste [Cost1]
Copy [MF]
Paste [MF1]
Pause/Resume Script [indefinitely]
End if
If[not IsEmpty[Name]
Paste [Name2]
Copy [Name2]
Paste [Cost2]
Copy [MF]
Paste [MF2]
Pause/Resume Script [indefinitely]
End if
End Loop
This only allows me to copy into the first or second row depending upon
whether or not the first row is empty. I need to be able to follow the
same premise for the 3rd and 4th rows as well. Can anyone help?

Sent via Deja.com http://www.***.com/
Before you buy.



Thu, 12 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)

What are you calling a row (portal rows)?

Anxious to Help,

Robert Farkas
MCSE,CNE,CCA
Systems Engineer

Quote:

> I can do this with the If statement and IsEmpty but can only loop
> twice (to the first row if it's empty and the 2nd if the first is not
> empty). I have 75 rows with 3fields in each row, Name, Cost & MF. I'd
> like the user to be able to chose a row and copy all three fields into a
> blank rows (There are 4 blank rows-Name1, Cost1 & MF1; Name2, Cost2, &
> MF2; Name3, Cost3 & MF3; Name4, Cost4, MF4). The script reads as
> follows:
> Loop
> Copy [Name]
> If[IsEmpty(Name1)]
> Paste [Name1]
> Copy [Cost]
> Paste [Cost1]
> Copy [MF]
> Paste [MF1]
> Pause/Resume Script [indefinitely]
> End if
> If[not IsEmpty[Name]
> Paste [Name2]
> Copy [Name2]
> Paste [Cost2]
> Copy [MF]
> Paste [MF2]
> Pause/Resume Script [indefinitely]
> End if
> End Loop
> This only allows me to copy into the first or second row depending upon
> whether or not the first row is empty. I need to be able to follow the
> same premise for the 3rd and 4th rows as well. Can anyone help?

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Thu, 12 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
No, not a portal row.  Actually specific fields that I've created to
retain this data.  Any ideas?


Quote:

> What are you calling a row (portal rows)?

> Anxious to Help,

> Robert Farkas
> MCSE,CNE,CCA
> Systems Engineer




Quote:
> > I can do this with the If statement and IsEmpty but can only loop
> > twice (to the first row if it's empty and the 2nd if the first is
not
> > empty). I have 75 rows with 3fields in each row, Name, Cost & MF.
I'd
> > like the user to be able to chose a row and copy all three fields
into a
> > blank rows (There are 4 blank rows-Name1, Cost1 & MF1; Name2, Cost2,
&
> > MF2; Name3, Cost3 & MF3; Name4, Cost4, MF4). The script reads as
> > follows:
> > Loop
> > Copy [Name]
> > If[IsEmpty(Name1)]
> > Paste [Name1]
> > Copy [Cost]
> > Paste [Cost1]
> > Copy [MF]
> > Paste [MF1]
> > Pause/Resume Script [indefinitely]
> > End if
> > If[not IsEmpty[Name]
> > Paste [Name2]
> > Copy [Name2]
> > Paste [Cost2]
> > Copy [MF]
> > Paste [MF2]
> > Pause/Resume Script [indefinitely]
> > End if
> > End Loop
> > This only allows me to copy into the first or second row depending
upon
> > whether or not the first row is empty. I need to be able to follow
the
> > same premise for the 3rd and 4th rows as well. Can anyone help?

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy.


Sun, 15 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
Actually, I just want to copy the contents of 3 or 4 different fields
into 3 or 4 other fields (all at once).


Quote:

> What are you calling a row (portal rows)?

> Anxious to Help,

> Robert Farkas
> MCSE,CNE,CCA
> Systems Engineer




Quote:
> > I can do this with the If statement and IsEmpty but can only loop
> > twice (to the first row if it's empty and the 2nd if the first is
not
> > empty). I have 75 rows with 3fields in each row, Name, Cost & MF.
I'd
> > like the user to be able to chose a row and copy all three fields
into a
> > blank rows (There are 4 blank rows-Name1, Cost1 & MF1; Name2, Cost2,
&
> > MF2; Name3, Cost3 & MF3; Name4, Cost4, MF4). The script reads as
> > follows:
> > Loop
> > Copy [Name]
> > If[IsEmpty(Name1)]
> > Paste [Name1]
> > Copy [Cost]
> > Paste [Cost1]
> > Copy [MF]
> > Paste [MF1]
> > Pause/Resume Script [indefinitely]
> > End if
> > If[not IsEmpty[Name]
> > Paste [Name2]
> > Copy [Name2]
> > Paste [Cost2]
> > Copy [MF]
> > Paste [MF2]
> > Pause/Resume Script [indefinitely]
> > End if
> > End Loop
> > This only allows me to copy into the first or second row depending
upon
> > whether or not the first row is empty. I need to be able to follow
the
> > same premise for the 3rd and 4th rows as well. Can anyone help?

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy.


Sun, 15 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
What is it exactly that you're trying to accomplish (and why)? I ask because
there may be an easier/more elegant way.

To do what I think you want to do you could make each field a button and in
the script that's called use the Case statement to paste (actually SetField
is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

In most of my solutions it's rare that information needs to be duplicated. A
relationship to display the info is usually the best bet.

Nick Eide



Mon, 16 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
I really appreciate your response.  I'm new to FM PRO and I'm afraid
this one's got me stuck.  Here's an example of what I want to do:

Below are my fields with data:

PRODUCTS1, COSTS1 AND COLOR1
PRODUCTS2, COSTS2 AND COLOR2
PRODUCTS3, COSTS3 AND COLOR3
PRODUCTS4, COSTS4 AND COLOR4
PRODUCTS5, COSTS5 AND COLOR5
PRODUCTS6, COSTS6 AND COLOR6
ETC. (thru 75)

The user may make up to 4 choices.

When the user clicks onthe field, say, PRODUCTS1-- (which is an
invisible button) all three fields (PRODUCTS1, COSTS1 AND COLOR1 should
be copied into the appropriate blank field(s) as shown below:

Either
row 1) PRODUCTS1CHOICE, COSTS1CHOICE AND COLOR1CHOICE
row 2) PRODUCTS2CHOICE, COSTS2CHOICE AND COLOR2CHOICE
row 3) PRODUCTS3CHOICE, COSTS3CHOICE AND COLOR3CHOICE
row 4) PRODUCTS4CHOICE, COSTS4CHOICE AND COLOR4CHOICE

I have only been successful copying and pasting into the first two rows
using cut & paste with the "if IsEmpty and NotIsEmpty statement.  I'm
not familar with Case or Set Field.  Could I trouble you to give me an
example?  Any further assistance that you could give me would be GREATlY
appreciated.  Thanks again... mp


Quote:

> What is it exactly that you're trying to accomplish (and why)? I ask
because
> there may be an easier/more elegant way.

> To do what I think you want to do you could make each field a button
and in
> the script that's called use the Case statement to paste (actually
SetField
> is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

> In most of my solutions it's rare that information needs to be
duplicated. A
> relationship to display the info is usually the best bet.

> Nick Eide

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
I really appreciate your response.  I'm new to FM PRO and I'm afraid
this one's got me stuck.  Here's an example of what I want to do:

Below are my fields with data:

PRODUCTS1, COSTS1 AND COLOR1
PRODUCTS2, COSTS2 AND COLOR2
PRODUCTS3, COSTS3 AND COLOR3
PRODUCTS4, COSTS4 AND COLOR4
PRODUCTS5, COSTS5 AND COLOR5
PRODUCTS6, COSTS6 AND COLOR6
ETC. (thru 75)

The user may make up to 4 choices.

When the user clicks onthe field, say, PRODUCTS1-- (which is an
invisible button) all three fields (PRODUCTS1, COSTS1 AND COLOR1 should
be copied into the appropriate blank field(s) as shown below:

Either
row 1) PRODUCTS1CHOICE, COSTS1CHOICE AND COLOR1CHOICE
row 2) PRODUCTS2CHOICE, COSTS2CHOICE AND COLOR2CHOICE
row 3) PRODUCTS3CHOICE, COSTS3CHOICE AND COLOR3CHOICE
row 4) PRODUCTS4CHOICE, COSTS4CHOICE AND COLOR4CHOICE

I have only been successful copying and pasting into the first two rows
using cut & paste with the "if IsEmpty and NotIsEmpty statement.  I'm
not familar with Case or Set Field.  Could I trouble you to give me an
example?  Any further assistance that you could give me would be GREATlY
appreciated.  Thanks again... mp


Quote:

> What is it exactly that you're trying to accomplish (and why)? I ask
because
> there may be an easier/more elegant way.

> To do what I think you want to do you could make each field a button
and in
> the script that's called use the Case statement to paste (actually
SetField
> is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

> In most of my solutions it's rare that information needs to be
duplicated. A
> relationship to display the info is usually the best bet.

> Nick Eide

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
I really appreciate your response.  I'm new to FM PRO and I'm afraid
this one's got me stuck.  Here's an example of what I want to do:

Below are my fields with data:

PRODUCTS1, COSTS1 AND COLOR1
PRODUCTS2, COSTS2 AND COLOR2
PRODUCTS3, COSTS3 AND COLOR3
PRODUCTS4, COSTS4 AND COLOR4
PRODUCTS5, COSTS5 AND COLOR5
PRODUCTS6, COSTS6 AND COLOR6
ETC. (thru 75)

The user may make up to 4 choices.

When the user clicks onthe field, say, PRODUCTS1-- (which is an
invisible button) all three fields (PRODUCTS1, COSTS1 AND COLOR1 should
be copied into the appropriate blank field(s) as shown below:

Either
row 1) PRODUCTS1CHOICE, COSTS1CHOICE AND COLOR1CHOICE
row 2) PRODUCTS2CHOICE, COSTS2CHOICE AND COLOR2CHOICE
row 3) PRODUCTS3CHOICE, COSTS3CHOICE AND COLOR3CHOICE
row 4) PRODUCTS4CHOICE, COSTS4CHOICE AND COLOR4CHOICE

I have only been successful copying and pasting into the first two rows
using cut & paste with the "if IsEmpty and NotIsEmpty statement.  I'm
not familar with Case or Set Field.  Could I trouble you to give me an
example?  Any further assistance that you could give me would be GREATlY
appreciated.  Thanks again... mp


Quote:

> What is it exactly that you're trying to accomplish (and why)? I ask
because
> there may be an easier/more elegant way.

> To do what I think you want to do you could make each field a button
and in
> the script that's called use the Case statement to paste (actually
SetField
> is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

> In most of my solutions it's rare that information needs to be
duplicated. A
> relationship to display the info is usually the best bet.

> Nick Eide

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
I really appreciate your response.  I'm new to FM PRO and I'm afraid
this one's got me stuck.  Here's an example of what I want to do:

Below are my fields with data:

PRODUCTS1, COSTS1 AND COLOR1
PRODUCTS2, COSTS2 AND COLOR2
PRODUCTS3, COSTS3 AND COLOR3
PRODUCTS4, COSTS4 AND COLOR4
PRODUCTS5, COSTS5 AND COLOR5
PRODUCTS6, COSTS6 AND COLOR6
ETC. (thru 75)

The user may make up to 4 choices.

When the user clicks onthe field, say, PRODUCTS1-- (which is an
invisible button) all three fields (PRODUCTS1, COSTS1 AND COLOR1 should
be copied into the appropriate blank field(s) as shown below:

Either
row 1) PRODUCTS1CHOICE, COSTS1CHOICE AND COLOR1CHOICE
row 2) PRODUCTS2CHOICE, COSTS2CHOICE AND COLOR2CHOICE
row 3) PRODUCTS3CHOICE, COSTS3CHOICE AND COLOR3CHOICE
row 4) PRODUCTS4CHOICE, COSTS4CHOICE AND COLOR4CHOICE

I have only been successful copying and pasting into the first two rows
using cut & paste with the "if IsEmpty and NotIsEmpty statement.  I'm
not familar with Case or Set Field.  Could I trouble you to give me an
example?  Any further assistance that you could give me would be GREATlY
appreciated.  Thanks again... mp


Quote:

> What is it exactly that you're trying to accomplish (and why)? I ask
because
> there may be an easier/more elegant way.

> To do what I think you want to do you could make each field a button
and in
> the script that's called use the Case statement to paste (actually
SetField
> is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

> In most of my solutions it's rare that information needs to be
duplicated. A
> relationship to display the info is usually the best bet.

> Nick Eide

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
I really appreciate your response. I'm new to FM PRO and I'm afraid
this one's got me stuck. Here's an example of what I want to do:
Below are my fields with data:
PRODUCTS1, COSTS1 AND COLOR1
PRODUCTS2, COSTS2 AND COLOR2
PRODUCTS3, COSTS3 AND COLOR3
PRODUCTS4, COSTS4 AND COLOR4
PRODUCTS5, COSTS5 AND COLOR5
PRODUCTS6, COSTS6 AND COLOR6
ETC. (thru 75)
The user may make up to 4 choices.
When the user clicks onthe field, say, PRODUCTS1-- (which is an
invisible button) all three fields (PRODUCTS1, COSTS1 AND COLOR1 should
be copied into the appropriate blank field(s) as shown below:
Either
row 1) PRODUCTS1CHOICE, COSTS1CHOICE AND COLOR1CHOICE
row 2) PRODUCTS2CHOICE, COSTS2CHOICE AND COLOR2CHOICE
row 3) PRODUCTS3CHOICE, COSTS3CHOICE AND COLOR3CHOICE
row 4) PRODUCTS4CHOICE, COSTS4CHOICE AND COLOR4CHOICE
I have only been successful copying and pasting into the first two rows
using cut & paste with the "if IsEmpty and NotIsEmpty statement. I'm
not familar with Case or Set Field. Could I trouble you to give me an
example? Any further assistance that you could give me would be GREATlY
appreciated. Thanks again... mp

Quote:

> What is it exactly that you're trying to accomplish (and why)? I ask
because
> there may be an easier/more elegant way.

> To do what I think you want to do you could make each field a button
and in
> the script that's called use the Case statement to paste (actually
SetField
> is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

> In most of my solutions it's rare that information needs to be
duplicated. A
> relationship to display the info is usually the best bet.

> Nick Eide

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
I really appreciate your response. I'm new to FM PRO and I'm afraid
this one's got me stuck. Here's an example of what I want to do:
Below are my fields with data:
PRODUCTS1, COSTS1 AND COLOR1
PRODUCTS2, COSTS2 AND COLOR2
PRODUCTS3, COSTS3 AND COLOR3
PRODUCTS4, COSTS4 AND COLOR4
PRODUCTS5, COSTS5 AND COLOR5
PRODUCTS6, COSTS6 AND COLOR6
ETC. (thru 75)
The user may make up to 4 choices.
When the user clicks onthe field, say, PRODUCTS1-- (which is an
invisible button) all three fields (PRODUCTS1, COSTS1 AND COLOR1 should
be copied into the appropriate blank field(s) as shown below:
Either
row 1) PRODUCTS1CHOICE, COSTS1CHOICE AND COLOR1CHOICE
row 2) PRODUCTS2CHOICE, COSTS2CHOICE AND COLOR2CHOICE
row 3) PRODUCTS3CHOICE, COSTS3CHOICE AND COLOR3CHOICE
row 4) PRODUCTS4CHOICE, COSTS4CHOICE AND COLOR4CHOICE
I have only been successful copying and pasting into the first two rows
using cut & paste with the "if IsEmpty and NotIsEmpty statement. I'm
not familar with Case or Set Field. Could I trouble you to give me an
example? Any further assistance that you could give me would be GREATlY
appreciated. Thanks again... mp

Quote:

> What is it exactly that you're trying to accomplish (and why)? I ask
because
> there may be an easier/more elegant way.

> To do what I think you want to do you could make each field a button
and in
> the script that's called use the Case statement to paste (actually
SetField
> is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

> In most of my solutions it's rare that information needs to be
duplicated. A
> relationship to display the info is usually the best bet.

> Nick Eide

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
I really appreciate your response. I'm new to FM PRO and I'm afraid
this one's got me stuck. Here's an example of what I want to do:
Below are my fields with data:
PRODUCTS1, COSTS1 AND COLOR1
PRODUCTS2, COSTS2 AND COLOR2
PRODUCTS3, COSTS3 AND COLOR3
PRODUCTS4, COSTS4 AND COLOR4
PRODUCTS5, COSTS5 AND COLOR5
PRODUCTS6, COSTS6 AND COLOR6
ETC. (thru 75)
The user may make up to 4 choices.
When the user clicks onthe field, say, PRODUCTS1-- (which is an
invisible button) all three fields (PRODUCTS1, COSTS1 AND COLOR1 should
be copied into the appropriate blank field(s) as shown below:
Either
row 1) PRODUCTS1CHOICE, COSTS1CHOICE AND COLOR1CHOICE
row 2) PRODUCTS2CHOICE, COSTS2CHOICE AND COLOR2CHOICE
row 3) PRODUCTS3CHOICE, COSTS3CHOICE AND COLOR3CHOICE
row 4) PRODUCTS4CHOICE, COSTS4CHOICE AND COLOR4CHOICE
I have only been successful copying and pasting into the first two rows
using cut & paste with the "if IsEmpty and NotIsEmpty statement. I'm
not familar with Case or Set Field. Could I trouble you to give me an
example? Any further assistance that you could give me would be GREATlY
appreciated. Thanks again... mp

Quote:

> What is it exactly that you're trying to accomplish (and why)? I ask
because
> there may be an easier/more elegant way.

> To do what I think you want to do you could make each field a button
and in
> the script that's called use the Case statement to paste (actually
SetField
> is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

> In most of my solutions it's rare that information needs to be
duplicated. A
> relationship to display the info is usually the best bet.

> Nick Eide

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
I really appreciate your response. I'm new to FM PRO and I'm afraid
this one's got me stuck. Here's an example of what I want to do:
Below are my fields with data:
PRODUCTS1, COSTS1 AND COLOR1
PRODUCTS2, COSTS2 AND COLOR2
PRODUCTS3, COSTS3 AND COLOR3
PRODUCTS4, COSTS4 AND COLOR4
PRODUCTS5, COSTS5 AND COLOR5
PRODUCTS6, COSTS6 AND COLOR6
ETC. (thru 75)
The user may make up to 4 choices.
When the user clicks onthe field, say, PRODUCTS1-- (which is an
invisible button) all three fields (PRODUCTS1, COSTS1 AND COLOR1 should
be copied into the appropriate blank field(s) as shown below:
Either
row 1) PRODUCTS1CHOICE, COSTS1CHOICE AND COLOR1CHOICE
row 2) PRODUCTS2CHOICE, COSTS2CHOICE AND COLOR2CHOICE
row 3) PRODUCTS3CHOICE, COSTS3CHOICE AND COLOR3CHOICE
row 4) PRODUCTS4CHOICE, COSTS4CHOICE AND COLOR4CHOICE
I have only been successful copying and pasting into the first two rows
using cut & paste with the "if IsEmpty and NotIsEmpty statement. I'm
not familar with Case or Set Field. Could I trouble you to give me an
example? Any further assistance that you could give me would be GREATlY
appreciated. Thanks again... mp

Quote:

> What is it exactly that you're trying to accomplish (and why)? I ask
because
> there may be an easier/more elegant way.

> To do what I think you want to do you could make each field a button
and in
> the script that's called use the Case statement to paste (actually
SetField
> is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

> In most of my solutions it's rare that information needs to be
duplicated. A
> relationship to display the info is usually the best bet.

> Nick Eide

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
I really appreciate your response. I'm new to FM PRO and I'm afraid
this one's got me stuck. Here's an example of what I want to do:
Below are my fields with data:
PRODUCTS1, COSTS1 AND COLOR1
PRODUCTS2, COSTS2 AND COLOR2
PRODUCTS3, COSTS3 AND COLOR3
PRODUCTS4, COSTS4 AND COLOR4
PRODUCTS5, COSTS5 AND COLOR5
PRODUCTS6, COSTS6 AND COLOR6
ETC. (thru 75)
The user may make up to 4 choices.
When the user clicks onthe field, say, PRODUCTS1-- (which is an
invisible button) all three fields (PRODUCTS1, COSTS1 AND COLOR1 should
be copied into the appropriate blank field(s) as shown below:
Either
row 1) PRODUCTS1CHOICE, COSTS1CHOICE AND COLOR1CHOICE
row 2) PRODUCTS2CHOICE, COSTS2CHOICE AND COLOR2CHOICE
row 3) PRODUCTS3CHOICE, COSTS3CHOICE AND COLOR3CHOICE
row 4) PRODUCTS4CHOICE, COSTS4CHOICE AND COLOR4CHOICE
I have only been successful copying and pasting into the first two rows
using cut & paste with the "if IsEmpty and NotIsEmpty statement. I'm
not familar with Case or Set Field. Could I trouble you to give me an
example? Any further assistance that you could give me would be GREATlY
appreciated. Thanks again... mp

Quote:

> What is it exactly that you're trying to accomplish (and why)? I ask
because
> there may be an easier/more elegant way.

> To do what I think you want to do you could make each field a button
and in
> the script that's called use the Case statement to paste (actually
SetField
> is faster) into field 1, 2, 3, or 4 dependent on IsEmpty.

> In most of my solutions it's rare that information needs to be
duplicated. A
> relationship to display the info is usually the best bet.

> Nick Eide

Sent via Deja.com http://www.deja.com/
Before you buy.


Tue, 17 Sep 2002 03:00:00 GMT
 Copying multiple fields into the next blank field(s)
which one should I reply to? :)

I came up with a pretty nice solution, I think. I have FM 5.  If you have
the same I can send you the solution.  Just in case, it goes a little like
this:

Define Fields:
cConstant        Calculation            Indexed, =1
ID                    Text                    Indexed, Auto-enter Serial
Product            Text
Color                Text
Cost                Text
IDChoice        Calculation            SelfSelect::ID
Select            Text
SelectYes        Calculation            Indexed, ="yes"

Relationships:
Self                cConstant=::cConstant            File.fp5
SelfSelect        SelectYes=::Select                File.fp5

On the only layout you'll need you put the fields:
[ID, Products, Color, Cost, Select]
"Select" has a value list with choice of "yes".  The field is set up as a
check box.

There will also be two portals on the layout.  One, relationship "Self", has
the fields:
[Self::Select, Self::ID, Self::Products, Self::Color, Self::Cost]
Make sure it has a scroll bar and show 20 or so lines.

The other portal, relationship "SelfSelect", has the fields:
[SelfSelect::ID, SelfSelect::Products, SelfSelect::Color, SelfSelect::Cost]
Give it however many rows that are needed for products that will be
selected.

The "Self" portal shows all possibilities, the "SelfSelect" portal shows the
items selected when the "Select" field is checked.

If you need help with the portal and relational stuff, read the online help,
then let me know :)

To make it look good, you could just make relationship "Self" automatically
create new records and just enter the data into the (Self) portal itself.
No need to show the actual fields on the layout.

Nick Eide



Wed, 18 Sep 2002 03:00:00 GMT
 
 [ 16 post ]  Go to page: [1] [2]

 Relevant Pages 

1. Blank field not space in char and varchar field

2. VB5-Access:Jumping from a specific field to the next field

3. Incrementing Next Field's Value Based Upon Prior Field's Value

4. Copying data from a TEXT field into two Varchar fields

5. How to copy field values to another field within the same table

6. how to copy a db to another db table by table and field by field

7. Copying DAO.Field VALUES, as well as the field def.s / properties

8. Copy data from string field to memo field

9. Help: copy memo field from one table to another field

10. copying data from clob field into long field

11. copy data from clob field into long field

12. copying field data to another field


 
Powered by phpBB® Forum Software