Hello all:

I need something similar to a checkbox set, but with three coumns of
checkboxes.

Here is an example of what I want

Part Number Exists Entered Damaged
0169-571-00 x x
0169-572-00 x x
0169-579-00 x x

Part number set here is given. The rest of the columns change from
record to record.

I was thinking of creating a portal and inputting into the related
table four fields, the first being the part number.

Then each time a record is created the portal displays the set of part
numbers through the portal. User then only modifies the rest of the
fields to create a checkbox set effect.

However, I could not figure out a way of populating the part number
fiield with the set of predetermined numbers.

I wonder if I can copy a certain record --say Record 111-- each time a
new record is created, The Record 111 would be blank for all the
fields except for the portal, which would have all the part numbers in
place. I could not see among the script functions "copy Record 1111 to
the record being created" type of function.

Any suggestions?

Thanks,

Sam

On Aug 25, 11:26 pm, SamMc <FMP_acco... [at] hotmail.com> wrote:
> Hello all:
>
> I need something similar to a checkbox set, but with three coumns of
> checkboxes.
>
> Here is an example of what I want
>
> Part Number Exists Entered Damaged
> 0169-571-00 x x
> 0169-572-00 x x
> 0169-579-00 x x
>
> Part number set here is given. The rest of the columns change from
> record to record.
>
> I was thinking of creating a portal and inputting into the related
> table four fields, the first being the part number.
>
> Then each time a record is created the portal displays the set of part
> numbers through the portal. User then only modifies the rest of the
> fields to create a checkbox set effect.
>
> However, I could not figure out a way of populating the part number
> fiield with the set of predetermined numbers.
>
> I wonder if I can copy a certain record --say Record 111-- each time a
> new record is created, The Record 111 would be blank for all the
> fields except for the portal, which would have all the part numbers in
> place. I could not see among the script functions "copy Record 1111 to
> the record being created" type of function.
>
> Any suggestions?
>
> Thanks,
>
> Sam

By "function" above I mean "script step". Too late in the day, and I
am forgetting the proper terminology.

Sam

In article <1188110418.451323.314290 [at] q4g2000prc.googlegroups.com>,
SamMc <FMP_account [at] hotmail.com> wrote:

> On Aug 25, 11:26 pm, SamMc <FMP_acco... [at] hotmail.com> wrote:
> > Hello all:
> >
> > I need something similar to a checkbox set, but with three coumns of
> > checkboxes.
> >
> > Here is an example of what I want
> >
> > Part Number Exists Entered Damaged
> > 0169-571-00 x x
> > 0169-572-00 x x
> > 0169-579-00 x x
> >
> > Part number set here is given. The rest of the columns change from
> > record to record.
> >
> > I was thinking of creating a portal and inputting into the related
> > table four fields, the first being the part number.
> >
> > Then each time a record is created the portal displays the set of part
> > numbers through the portal. User then only modifies the rest of the
> > fields to create a checkbox set effect.
> >
> > However, I could not figure out a way of populating the part number
> > fiield with the set of predetermined numbers.
> >
> > I wonder if I can copy a certain record --say Record 111-- each time a
> > new record is created, The Record 111 would be blank for all the
> > fields except for the portal, which would have all the part numbers in
> > place. I could not see among the script functions "copy Record 1111 to
> > the record being created" type of function.
> >
> > Any suggestions?
> >
> > Thanks,
> >
> > Sam
>
> By "function" above I mean "script step". Too late in the day, and I
> am forgetting the proper terminology.
>
> Sam

Need to understand the relationship structure and layout structure,
which you do not explain. It would also help to get an overall
understanding of the business purpose of what you are trying to do, as
there may be a more effective way to do it than the approach you are
taking, whatever that is.

--
For email, change <fake> to <earthlink>
Bill Collins

Am I understanding this correctly?

This set of part number records is specific to a larger entity, such as
piece of equipment, and you want to be able to create a set of part
number records, populated only with the part number and related to the
equipment, so as to appear in a portal on this piece of equipment's record?

You don't provide your FM version or platform (specific version is
ALWAYS important in asking a question about FileMaker, platform only
sometimes, but do it anyway); answer assumes 7 or greater, either platform.

I'll call the tables Equipment and Parts, with a field Key to create the
relationship.

Yes, having a set of "template" records in Parts, pre-populated with the
part numbers, would be one way to go. The record should have a field in
it to identify it as a template, upon which you could perform a find.
We'll call that field Template, with a value of 1 in those records to be
duplicated, non-template records would be a 0 or null, your choice.

The scripting would be something like:

Set variable [ $Key ; Value:Equipment::Key ]
Go to Layout [ "Parts Layout" (Parts) ]
Perform Find [ Restore ] //find records in which Template = 1
Go to Record/Request/Page [ First ]
Loop
Duplicate Record/Request
Set Field [ Parts::Template ; "" ] //or 0
Set Field [ Parts::Key ; $Key ]
Go to Record/Request/Page [ Next ; exit after last ]
End Loop
Go to Layout [ original layout ].

Matt


SamMc wrote:
> Hello all:
>
> I need something similar to a checkbox set, but with three coumns of
> checkboxes.
>
> Here is an example of what I want
>
> Part Number Exists Entered Damaged
> 0169-571-00 x x
> 0169-572-00 x x
> 0169-579-00 x x
>
> Part number set here is given. The rest of the columns change from
> record to record.
>
> I was thinking of creating a portal and inputting into the related
> table four fields, the first being the part number.
>
> Then each time a record is created the portal displays the set of part
> numbers through the portal. User then only modifies the rest of the
> fields to create a checkbox set effect.
>
> However, I could not figure out a way of populating the part number
> fiield with the set of predetermined numbers.
>
> I wonder if I can copy a certain record --say Record 111-- each time a
> new record is created, The Record 111 would be blank for all the
> fields except for the portal, which would have all the part numbers in
> place. I could not see among the script functions "copy Record 1111 to
> the record being created" type of function.
>
> Any suggestions?
>
> Thanks,
>
> Sam
>

OOPS, sorry.

FileMaker 7 didn't have Script Variables. I don't remember offhand in
which version they first appeared.

You may have to create a global field to hold the value of Key and set
the Parts::Key field from that.

Matt

Matt Wills wrote:
> Am I understanding this correctly?
>
> This set of part number records is specific to a larger entity, such as
> piece of equipment, and you want to be able to create a set of part
> number records, populated only with the part number and related to the
> equipment, so as to appear in a portal on this piece of equipment's record?
>
> You don't provide your FM version or platform (specific version is
> ALWAYS important in asking a question about FileMaker, platform only
> sometimes, but do it anyway); answer assumes 7 or greater, either platform.
>
> I'll call the tables Equipment and Parts, with a field Key to create the
> relationship.
>
> Yes, having a set of "template" records in Parts, pre-populated with the
> part numbers, would be one way to go. The record should have a field in
> it to identify it as a template, upon which you could perform a find.
> We'll call that field Template, with a value of 1 in those records to be
> duplicated, non-template records would be a 0 or null, your choice.
>
> The scripting would be something like:
>
> Set variable [ $Key ; Value:Equipment::Key ]
> Go to Layout [ "Parts Layout" (Parts) ]
> Perform Find [ Restore ] //find records in which Template = 1
> Go to Record/Request/Page [ First ]
> Loop
> Duplicate Record/Request
> Set Field [ Parts::Template ; "" ] //or 0
> Set Field [ Parts::Key ; $Key ]
> Go to Record/Request/Page [ Next ; exit after last ]
> End Loop
> Go to Layout [ original layout ].
>
> Matt
>
>
> SamMc wrote:
>> Hello all:
>>
>> I need something similar to a checkbox set, but with three coumns of
>> checkboxes.
>>
>> Here is an example of what I want
>>
>> Part Number Exists Entered Damaged
>> 0169-571-00 x x
>> 0169-572-00 x x
>> 0169-579-00 x x
>>
>> Part number set here is given. The rest of the columns change from
>> record to record.
>>
>> I was thinking of creating a portal and inputting into the related
>> table four fields, the first being the part number.
>>
>> Then each time a record is created the portal displays the set of part
>> numbers through the portal. User then only modifies the rest of the
>> fields to create a checkbox set effect.
>>
>> However, I could not figure out a way of populating the part number
>> fiield with the set of predetermined numbers.
>>
>> I wonder if I can copy a certain record --say Record 111-- each time a
>> new record is created, The Record 111 would be blank for all the
>> fields except for the portal, which would have all the part numbers in
>> place. I could not see among the script functions "copy Record 1111 to
>> the record being created" type of function.
>>
>> Any suggestions?
>>
>> Thanks,
>>
>> Sam
>>

--
Free FileMaker Technique Demos: http://www.VirtualVermont.com/FMP

My Custom Functions:
http://www.briandunning.com/filemaker-custom-functions/resul ts.php?keyword=wills

Hello Matt:

Yes, your understanding is correct. I use version 8.5, and on the XP
platform.

I will try your suggestion.

Sam

On Aug 26, 5:48 am, Matt Wills <I... [at] witz.end> wrote:
> Am I understanding this correctly?
>
> This set of part number records is specific to a larger entity, such as
> piece of equipment, and you want to be able to create a set of part
> number records, populated only with the part number and related to the
> equipment, so as to appear in a portal on this piece of equipment's record?
>
> You don't provide your FM version or platform (specific version is
> ALWAYS important in asking a question about FileMaker, platform only
> sometimes, but do it anyway); answer assumes 7 or greater, either platform.
>
> I'll call the tables Equipment and Parts, with a field Key to create the
> relationship.
>
> Yes, having a set of "template" records in Parts, pre-populated with the
> part numbers, would be one way to go. The record should have a field in
> it to identify it as a template, upon which you could perform a find.
> We'll call that field Template, with a value of 1 in those records to be
> duplicated, non-template records would be a 0 or null, your choice.
>
> The scripting would be something like:
>
> Set variable [ $Key ; Value:Equipment::Key ]
> Go to Layout [ "Parts Layout" (Parts) ]
> Perform Find [ Restore ] //find records in which Template = 1
> Go to Record/Request/Page [ First ]
> Loop
> Duplicate Record/Request
> Set Field [ Parts::Template ; "" ] //or 0
> Set Field [ Parts::Key ; $Key ]
> Go to Record/Request/Page [ Next ; exit after last ]
> End Loop
> Go to Layout [ original layout ].
>
> Matt
>
>
>
> SamMc wrote:
> > Hello all:
>
> > I need something similar to a checkbox set, but with three coumns of
> > checkboxes.
>
> > Here is an example of what I want
>
> > Part Number Exists Entered Damaged
> > 0169-571-00 x x
> > 0169-572-00 x x
> > 0169-579-00 x x
>
> > Part number set here is given. The rest of the columns change from
> > record to record.
>
> > I was thinking of creating a portal and inputting into the related
> > table four fields, the first being the part number.
>
> > Then each time a record is created the portal displays the set of part
> > numbers through the portal. User then only modifies the rest of the
> > fields to create a checkbox set effect.
>
> > However, I could not figure out a way of populating the part number
> > fiield with the set of predetermined numbers.
>
> > I wonder if I can copy a certain record --say Record 111-- each time a
> > new record is created, The Record 111 would be blank for all the
> > fields except for the portal, which would have all the part numbers in
> > place. I could not see among the script functions "copy Record 1111 to
> > the record being created" type of function.
>
> > Any suggestions?
>
> > Thanks,
>
> > Sam- Hide quoted text -
>
> - Show quoted text -

On Aug 26, 5:33 am, Bill <bbcoll... [at] fake.net> wrote:
> In article <1188110418.451323.314... [at] q4g2000prc.googlegroups.com>,
>
>
>
>
>
> SamMc <FMP_acco... [at] hotmail.com> wrote:
> > On Aug 25, 11:26 pm, SamMc <FMP_acco... [at] hotmail.com> wrote:
> > > Hello all:
>
> > > I need something similar to a checkbox set, but with three coumns of
> > > checkboxes.
>
> > > Here is an example of what I want
>
> > > Part Number Exists Entered Damaged
> > > 0169-571-00 x x
> > > 0169-572-00 x x
> > > 0169-579-00 x x
>
> > > Part number set here is given. The rest of the columns change from
> > > record to record.
>
> > > I was thinking of creating a portal and inputting into the related
> > > table four fields, the first being the part number.
>
> > > Then each time a record is created the portal displays the set of part
> > > numbers through the portal. User then only modifies the rest of the
> > > fields to create a checkbox set effect.
>
> > > However, I could not figure out a way of populating the part number
> > > fiield with the set of predetermined numbers.
>
> > > I wonder if I can copy a certain record --say Record 111-- each time a
> > > new record is created, The Record 111 would be blank for all the
> > > fields except for the portal, which would have all the part numbers in
> > > place. I could not see among the script functions "copy Record 1111 to
> > > the record being created" type of function.
>
> > > Any suggestions?
>
> > > Thanks,
>
> > > Sam
>
> > By "function" above I mean "script step". Too late in the day, and I
> > am forgetting the proper terminology.
>
> > Sam
>
> Need to understand the relationship structure and layout structure,
> which you do not explain. It would also help to get an overall
> understanding of the business purpose of what you are trying to do, as
> there may be a more effective way to do it than the approach you are
> taking, whatever that is.
>
> --
> For email, change <fake> to <earthlink>
> Bill Collins- Hide quoted text -
>
> - Show quoted text -

Bill,

We have a number of products that come back from our customers for
repairs. The DB keeps track of the repairs--what was wrong, what we
did, some operational parameters etc.

One of the things we want to do is to create a list of parts we
replace.

My goal here is to enumurate all these parts. The tech simply mark
next to it when he changes one. He also marks if the part replaced was
returned from the customer (hence, "exists"), etc.

The main layout has the data from our repair activity, entered into
the main table. This has been going on for the past two years or so.

One of our engineers suggested a list for the commonly replaced parts,
with the three pieces of binary data for each part I sketched above.
He sees the checkbox list I created for some of the fields, so he
though we could have three sets of checkboxes.

Regards,

Sam