I have two databases machine inventory and maintenance records.

If I do a maintence action and enter 1 in the id field it pulls up model #
serial # ect. for that machine so I don't have to type it. I then enter
action, man hours etc.

If I'm in the inventory database and looking at a particular machine what is
the best way to display maintenance records for that machine? I tried to
write a script to open the maintenance records database, do a search for the
ID of the machine I'm looking at and go to layout which would display all
those records but it's not doing what I want.


-- 
===================================================================
"When a broad table is to be made, and the edges of planks do not fit, the
artist takes a little from both, and makes a good joint.  In like manner
here, both sides must part with some of their demands," Benjamin Franklin
(1706-1790)
===================================================================

Set up a relationship from the ID field in Inventory to the ID field in 
maintenance.  Using that relationship, you can create a portal on your 
inventory screen to show maintenance records for that inventory item. Or 
else use a button or script with the 'go to related record' script step 
and mark the option for that step to 'show only related' records.

The Wolf wrote:

> I have two databases machine inventory and maintenance records.
> 
> If I do a maintence action and enter 1 in the id field it pulls up model #
> serial # ect. for that machine so I don't have to type it. I then enter
> action, man hours etc.
> 
> If I'm in the inventory database and looking at a particular machine what is
> the best way to display maintenance records for that machine? I tried to
> write a script to open the maintenance records database, do a search for the
> ID of the machine I'm looking at and go to layout which would display all
> those records but it's not doing what I want.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance

On 9/22/03 1:32 PM, in article vmtugab2thvh71@corp.supernews.com, "Howard
Schlossberg" <howard@antispahm.fmprosolutions.com> opined:

> Set up a relationship from the ID field in Inventory to the ID field in
> maintenance.  Using that relationship, you can create a portal on your
> inventory screen to show maintenance records for that inventory item. Or
> else use a button or script with the 'go to related record' script step
> and mark the option for that step to 'show only related' records.
> 
> The Wolf wrote:
> 
>> I have two databases machine inventory and maintenance records.
>> 
>> If I do a maintence action and enter 1 in the id field it pulls up model #
>> serial # ect. for that machine so I don't have to type it. I then enter
>> action, man hours etc.
>> 
>> If I'm in the inventory database and looking at a particular machine what is
>> the best way to display maintenance records for that machine? I tried to
>> write a script to open the maintenance records database, do a search for the
>> ID of the machine I'm looking at and go to layout which would display all
>> those records but it's not doing what I want.
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg              (818) 883-2846
> FM Pro Solutions       Los Angeles, California
> Associate Member, FileMaker Solutions Alliance
> 

Thank you!
-- 
===================================================================
"When a broad table is to be made, and the edges of planks do not fit, the
artist takes a little from both, and makes a good joint.  In like manner
here, both sides must part with some of their demands," Benjamin Franklin
(1706-1790)
===================================================================

On 9/22/03 2:26 PM, in article BB945480.3CF10%elvispmpsd@earthlink.net, "The
Wolf" <elvispmpsd@earthlink.net> opined:

> On 9/22/03 1:32 PM, in article vmtugab2thvh71@corp.supernews.com, "Howard
> Schlossberg" <howard@antispahm.fmprosolutions.com> opined:
> 
>> Set up a relationship from the ID field in Inventory to the ID field in
>> maintenance.  Using that relationship, you can create a portal on your
>> inventory screen to show maintenance records for that inventory item.



Set up relationship ID = ID but portal on inventory screen is blank. Show 6
rows is checked. 

Sorry, I am missing something rudimentary.



 Or
>> else use a button or script with the 'go to related record' script step
>> and mark the option for that step to 'show only related' records.
>> 
>> The Wolf wrote:
>> 
>>> I have two databases machine inventory and maintenance records.
>>> 
>>> If I do a maintence action and enter 1 in the id field it pulls up model #
>>> serial # ect. for that machine so I don't have to type it. I then enter
>>> action, man hours etc.
>>> 
>>> If I'm in the inventory database and looking at a particular machine what is
>>> the best way to display maintenance records for that machine? I tried to
>>> write a script to open the maintenance records database, do a search for the
>>> ID of the machine I'm looking at and go to layout which would display all
>>> those records but it's not doing what I want.
>> 
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Howard Schlossberg              (818) 883-2846
>> FM Pro Solutions       Los Angeles, California
>> Associate Member, FileMaker Solutions Alliance
>> 
> 
> Thank you!

The Wolf wrote:
>>On 9/22/03 1:32 PM, in article vmtugab2thvh71@corp.supernews.com, "Howard
>>Schlossberg" <howard@antispahm.fmprosolutions.com> opined:
>>
>>>Set up a relationship from the ID field in Inventory to the ID field in
>>>maintenance.  Using that relationship, you can create a portal on your
>>>inventory screen to show maintenance records for that inventory item.
> 
> Set up relationship ID = ID but portal on inventory screen is blank. Show 6
> rows is checked. 
> 
> Sorry, I am missing something rudimentary.

The portal should be based on that relationship, and the fields placed 
in the portal must also be based on that same relationship.  Place the 
fields on the first line of the portal, and make sure the top and left 
sides of the field are below the top of the portal.  Also be sure the ID 
fields in both files are defined to be of the same data type (number or 
text).  Let us know if you still have problems.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance

On 9/22/03 2:26 PM, in article BB945480.3CF10%elvispmpsd@earthlink.net, "The
Wolf" <elvispmpsd@earthlink.net> opined:

 Or
>> else use a button or script with the 'go to related record' script step
>> and mark the option for that step to 'show only related' records.
>> 
>
This option works fine, but how do I display the layout in the maintenance
database I want? Since I'm running the script from the inventory database in
the edit scripts dialogue it only allows me to choose layouts in the
inventory database.

"The Wolf" <elvispmpsd@earthlink.net> wrote in message
news:BB946097.3CF19%elvispmpsd@earthlink.net...
> On 9/22/03 2:26 PM, in article BB945480.3CF10%elvispmpsd@earthlink.net,
"The
> Wolf" <elvispmpsd@earthlink.net> opined:
>
>  Or
> >> else use a button or script with the 'go to related record' script step
> >> and mark the option for that step to 'show only related' records.
> >>
> >
> This option works fine, but how do I display the layout in the maintenance
> database I want? Since I'm running the script from the inventory database
in
> the edit scripts dialogue it only allows me to choose layouts in the
> inventory database.
>

Create a script in the maintenance database that goes to the appropriate
layout.  Then call that External script at the end of the script in the
inventory database.

On 9/22/03 3:52 PM, in article vmu6mlq56upe6f@corp.supernews.com, "Glenn
Schwandt" <schwandtgat@aoldot.com> opined:

> 
> "The Wolf" <elvispmpsd@earthlink.net> wrote in message
> news:BB946097.3CF19%elvispmpsd@earthlink.net...
>> On 9/22/03 2:26 PM, in article BB945480.3CF10%elvispmpsd@earthlink.net,
> "The
>> Wolf" <elvispmpsd@earthlink.net> opined:
>> 
>>  Or
>>>> else use a button or script with the 'go to related record' script step
>>>> and mark the option for that step to 'show only related' records.
>>>> 
>>> 
>> This option works fine, but how do I display the layout in the maintenance
>> database I want? Since I'm running the script from the inventory database
> in
>> the edit scripts dialogue it only allows me to choose layouts in the
>> inventory database.
>> 
> 
> Create a script in the maintenance database that goes to the appropriate
> layout.  Then call that External script at the end of the script in the
> inventory database.
> 
> 
Thank you both, you've been EXTREMELY helpful, I have both scenarios working
now :-)
-- 
===================================================================
"When a broad table is to be made, and the edges of planks do not fit, the
artist takes a little from both, and makes a good joint.  In like manner
here, both sides must part with some of their demands," Benjamin Franklin
(1706-1790)
===================================================================

The Go To Related Record step will go to the last layout you were on in 
the maintainence database.  The alternative is to create a script in the 
Maintenance file that goes to the correct layout.  Then in your 
inventory file, have your script do the GTRR step followed by a Perform 
Script[External] to run the script in Maintenance that goes to the 
correct layout.

The Wolf wrote:

> On 9/22/03 2:26 PM, in article BB945480.3CF10%elvispmpsd@earthlink.net, "The
> Wolf" <elvispmpsd@earthlink.net> opined:
> 
>  Or
> 
>>>else use a button or script with the 'go to related record' script step
>>>and mark the option for that step to 'show only related' records.
>>>
>>
> This option works fine, but how do I display the layout in the maintenance
> database I want? Since I'm running the script from the inventory database in
> the edit scripts dialogue it only allows me to choose layouts in the
> inventory database.
> 

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance

On 9/22/03 5:57 PM, in article vmue0b8uv9ve6f@corp.supernews.com, "Howard
Schlossberg" <howard@antispahm.fmprosolutions.com> opined:

Now I have a small problem. I changed the market rate (labor) to $40 now the
calculation manhours * market rate no longer works. For a while it was
displaying the old market rate even though I changed it.

How do I get it to re calc everything based on the new market rate?
===================================================================
"When a broad table is to be made, and the edges of planks do not fit, the
artist takes a little from both, and makes a good joint.  In like manner
here, both sides must part with some of their demands," Benjamin Franklin
(1706-1790)
===================================================================