Greetings from the same industry ("ModJunk" refers to Modesto Junk Company).
I think you are describing an inventory log system where you can log in items as they are received and log out items as they are sold with a balance calculation to tell you what totals of each material you currently have on hand.
Is this what you need?
Thank you very much for your email.
Greeting from "Metal You Recycling" in Hong Kong and China.
That is correct. I am trying to put a some sore of inventory log system, where we can keep track arrival of containers to Hong Kong yard or China warehouse. Or, local items purchased from local market.
So, I have been working on it, and this is the final part of the whole system.
Any suggestion how will it be the table relationship?
Thank you in advance.
There are several threads here in the forum that discuss an "inventory log" system: http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&message.id=21633
In your case, you'll need a "location table" where you can create a record for each shipping container and records for each location that isn't a shipping container such as the local "yard" for material received locally.
Define a serial number field for your location table and link it to an added locationID field in the inventory log table. This will allow you to set up a portal on your container table that can be used to log the reception of each material shipped in a given container directly into your inventory log.
Thank you very much for the information.
Don't feel suprise ,if in the future, my company passes offers for non-ferrous to ModJunk. Even we just move in European market, we have been considering to purchase from other countries, which uses USdollars as currency.