On your other thread:
The structure I proposed would lend itself well to this need. Each Lot# sheet could simply be a "Batch#" sheet with its own use-by date. You could view them from teh "Materials" table through a portal and see all batches of that material along with their respective Use-by dates.
This is great really i appreciate your time although i am still fairly new to filemaker would it be possible if you could help even more and explain how to create these relationships and tables sorry to be a pain...