I am still puzzled by this there has to be a way to pull from a list of items and the updated quanities to show on one record then update the info without compromising the record.

I cant get passed this part.

I use a drop down list of available items and select an item number. Based on the number I select shows the Qty and I enter in the amount of that quantity used and that completes a record. But when i update my inventory with new numbers the records then update which defeats the purpose. Am I missing something here?

What is your structure? Can you describe the tables you have and their relationships?

Jobs and JobLineItems? On JobLI you specify ItemIDs, and enter a Qty Used?

Back at the Item record, you calculate Qty in Stock?

I am still puzzled by this there has to be a way to pull from a list of items and the updated quanities to show on one record then update the info without compromising the record.

I cant get passed this part.

I use a drop down list of available items and select an item number. Based on the number I select shows the Qty and I enter in the amount of that quantity used and that completes a record. But when i update my inventory with new numbers the records then update which defeats the purpose. Am I missing something here?

Your request is incompehensible. Please post an example file.

I just want records once complete not to update once I import an updated inventory xls file.

I create a job and select from drop downs the items I am using. Based on Selection the qty appears in a separate field. I then input how much used per item and it creates a calculation. Its an enormous amount of calcs that make up the final result. Once complete the following day I update my inventory via script which imports an updated xls file of my current on hand inventory. Once I do this any old record updates to the new inventory and just want it to stop. I can manually type in each item but that defeats the purpose of using FM. I am trying to make less work for myself not more.

UPDATE: Finally I solved my issue. Instead of specifying the field to autodraw from the related table I now have it set to do a look up of the related table. Doing so it doesn't update the field once the item is selected. Not sure why it does it but it works... No more updating existing records

Edited April 8, 200916 yr by Guest