Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Problem moving inventory....


Recommended Posts

I am having problems with my "current inventory." As a car dealer, I sometimes enter vehicles that are trade-ins and/or end up being sold at auctions or sent to our other dealership that does not use FileMaker. I DO NOT want to delete the records...but I don't want the "old" inventory clogging up my current inventory list.


Is there any way for me to move these items (without having to make them "sold") from my current inventory without deleting them?


Please HELP!

Link to comment
Share on other sites

Depending on how your solution is built, one option is simply to have a status field on the Inventory records, and change it to "Deleted" for those you don't wish to dislay. this means having to modify the solution in some areas ie portals/found sets, to only show inventory records with non-deleted statuses.


Another option which might be more viable, is to create a new table, called "Old Inventory" for example. Make this an exact copy of the Inventory table (if you have Filemaker advanced you can copy/paste the inventory table & rename it).


Then, when you wish to move an item from your inventory to the old inventory, press a button that runs a script to do this, your script might go along the lines of:



1. Ask for user confirmation to move item to old inventory

2. User presses Yes/Ok

3. Import the Inventory record in question, into the Inventory Old table

4. Delete the Inventory record out of the Inventory table.


thats the basics, the actual script to do this might be a bit more complex (especially if you plan to use the import records script step).




Another possiblity, if your inventory table has relatively few fields (10-20 maybe), you can run a script to capture all the current inventory record fields into variables, go to the Inventory Old table, create a new record, paste all the values into it, then go back to the Inventory record & delete it, ie:


(you are currently on the inventory record you want to delete)..


Set Variable [ $Inventory Number ; Inventory::Number ]

Set Variable [ $Name ; Inventory::Name ]

Set Variable [ $Description ; Inventory::Description ]


... (etc)...


Go to Layout [ Inventory Old ]

New Record/Request

Set Field [ Inventory Old::Number ; $Inventory Number ]

Set Field [ Inventory Old::Name ; $Name ]

Set Field [ Inventory Old::Description ; $Description ]

Go to Layout [ Original Layout ]

Delete Record/Request

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use