Making a record inactive

[Opieos]

Hey gang.

Sorry if this is posted to the wrong forum. I have developed a File maker 8 solution running on Win XP Pro to track the inventory and maintenance for a fleet of vehicles. When a vehicle is entered into a record it is tracked by the VIN (vehicle Identification number) and a car number. (ie license plate)

The problem being when we receive new cars the license number is then removed from the old car and put on the new car (currently a new record with the old license number and new VIN is produced). I would like to be able to set the old records to be inactive, in others words not allowing entry or changes to the old records (so that it is available but not listed when a search is conducted for the license number)

Can this be accomplished by means of using a check box or what would be the best route? Any help is greatly appreciated

Edited January 20, 2006 by Guest

[Ender]

Welcome Oploes,

This is easy to do if you use a Status field to indicate "Active" and "Inactive" vehicles. Then you can include "Active" as a criteria in the find:

Enter Find Mode []

Set Field [ Status ; "Active" ]

Pause Script []

Perform Find []

...

Likewise, the Status can be included as a relationship filter by adding a globally stored text field gStatus, inserting the text "Active" into the field, and adding a relationship match between gStatus and the Status field on those relationships where it's needed.

As for limiting edit access to Inactive records, this can be done in the privilege set's custom privileges for Records.

Let us know if you get stuck.

[Opieos]

Thanks ender that works for what I was looking to do

[TraderBill]

I will also say "Thanks a Million". I needed an answer to that exact situation!

It is absolutely wonderful that you guys are willing to help us newbys! I hope that I can get to a level where I can also help.

...TraderBill