What are the proper script steps to copy from one layout (getting a
part number) and paste in a different layout, WITH 10 repeating
fields.

Thanks

Regardless of how many repeating fields you can do the following;
copy [FieldName]
go to layout [LayoutName]
paste [OtherFieldName]

A better way to do it would be to use set fields and globals since that
won't screw up the contents of your clipboard but there's nothing wrong
with the above

And a better way still (IMHO) is stop using repeating fields.

With repeating fields more problems are lurking along the way.

Ursus

"FP" <a (AT) pottnerconsulting (DOT) ca> schreef in bericht
news:1128487910.591510.73130 (AT) g47g2000cwa (DOT) googlegroups.com...

If this is true, why has FileMaker continued support for repeating
fields thru ver. 8?

One reason is certainly backwards compatibility, however, FM has added
functionality for repeaters, as well. There are many perfectly
acceptable, non-treacherous uses for repeaters.

I would agree that repeating fields should never be used to simulate
relational structure, but to dismiss them wholesale is ridiculous.

Michael Myett


ursus.kirk wrote:

Well, I'm using them (repeating fields) as a way to enter data for
quotes to a customer, who have more than 1 part number (up to 10) on
there quote. Is there a better way?
I've got the copy and paste down, but it always goes back to the first
field. I can't enter any more than one.



On Wed, 05 Oct 2005 09:48:09 -0400, Michael Myett
<michael.myett (AT) adelphia (DOT) net> wrote:

You should be using an invoicing system with seperate tables or files
for customers, parts, line items and quotes.

There are several example solutions on the FileMaker website, that you
can adapt or modify or just learn from. Business Tracker, Solution
Framework or the Business Productivity Kit. The one you use will depend
largely on which version of FM your using

Michael Myett

leekirb (AT) sbcglobal (DOT) net wrote:

leekirb (AT) sbcglobal (DOT) net wrote on (10/5/2005):

For one thing, you're limiting a quote to ten items. What if the customer
wants 11, not to mention 25 or 100? Multiple quotes? (Yikes!) A related
table displayed in a portal would allow as many items as necessary.

For another, you can control which portal row you go to a lot easier than
which repetition. To my knowledge, there is no way to specify a repetition
dynamically.

If a customer accepts some but not all of the items quoted, what happens?
With a related table, you could mark individual items as accepted or
rejected, which in turn could set them up a pick or work order and the
invoice as well. That may be possible with repeaters, but the lack of
dynamic identification and the manual actions necessary would be a
nightmare.

I'll agree, there is a use for repeaters, but only in situations where
there is no dynamic manipulation of data necessary. Window coordinates
comes to mind, situations involving control flags, when specific data
always goes in a specific repetition, but not much else.

Matt

Here is an example of using globals and set fields to create a new
record with certain preset values - some derived from the current record.
Michael Paine
-----------------
Set Variable [ $$TEST_CAT; Value:"POLE" ]
Set Variable [ $$MODEL_CD; Value:VEHICLE_MODEL::MODEL_ID ]
Set Variable [ $$CRASH_CD; Value:$$model_cd & "/" & $$TEST_CAT ]
....
Go to Layout [ “CRASH_DETAILS” (CRASH) ]
Show All Records
New Record/Request
Set Field [ CRASH::MODEL_ID; $$MODEL_CD ]
Set Field [ CRASH::CRASH_ID; $$crash_CD ]
Set Field [ CRASH::TEST_TYPE; $$TEST_CAT ]




----------------
FP wrote: