Re: Help needed with creating three columns of checkboxes

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/results.php?keyword=wills
.

Relevant Pages

  • Re: Sharing templates on the network
    ... (The script wraps a little from the news group formatting, ... ' 2) Copies the template to the folder specified by the user's ... ' network -- you either need to have every user close any documents ... ' Create a new document based upon the desired template that is now ...
    (microsoft.public.word.docmanagement)
  • Re: Previous record
    ... I'm looking for some help with FileMaker Pro 4 on a Mac.... ... The same Script could then Export the records, ... First perform a Sort and Export manually so that FileMaker knows what ... to be able to compare it with each record through the loop. ...
    (comp.databases.filemaker)
  • Re: forcing re-index
    ... I'm actually a fairly experienced filemaker developer. ... Is there a way that I can force indexing to re-occur everytime the contents of a field is changed, with a script step, or by using some script step that indirectly causes re-indexing to occur. ... In this case, I CAN associate a script step with leaving the field, because the field only occurs in a special window that comes up, and the user has to click a button to close that window. ...
    (comp.databases.filemaker)
  • Re: how to embed data in perl programs
    ... Since a program has only one source file there can be only ... the script needs to output one of these template files. ... a template base class and, for every template, a separate subclass. ...
    (perl.beginners)
  • Re: how to embed data in perl programs
    ... It looks like here-doc serves the purpose well. ... the script needs to output one of these template files. ...
    (perl.beginners)
Quantcast