Hercynium

CobaltSky, I think your suggestion is what I'm looking for... I hadn't thought about using a global field and a second "panel" (I think I understand what you meant) Actually, it sounds like a great little feature as this way my employees can read the extended description (and eventually see pictures!) to customers as they phone in an order! And Ugo, Thank you for your suggestions, though I think you're just getting ahead of me! Since we're currently such a disorganized place (right now) we don't have any real inventory so I'm not bothering to keep one in this version of the database! Each item is only known to be in stock, out of stock, or on-order... But very soon we'll start trying to keep count by multiples of Pack or Master Case... Qty_Packed is probably more accurate as Qty_Shipped! Well, it's back to work for me. Thanks for all the advice!

Well, I'll explore this route, but it doesn't seem to be a solution to what I am trying to do. I've been playing around with scripts, trying to get the desired results, and I think I may be on the right path, but I was hoping there would be a more direct and elegant method. What I'm specifically attempting to do is modify a record in the Inventory database from a layout in the Invoice database. Another route I am about to try is making a layout in the Line Item database... and seeing if I can do it from there. Anyhow, all comments offered are welcome... like I said, I'm new to Filemaker (though I've been reading up on it as much as possible!)

Hi, folks. I'm new here, and to Filemaker in general, and I need some help. I have a database system that I am working on that is growing in all sorts of directions but the relevant files to my question are Invoice, Line Items, and Inventory. For entering a new order I have set up a layout in the Invoice file that includes a portal to the Line Items file. As each item number is typed into the portal the related info from the Inventory file is looked up and copied into the relevant fields. I then enter in the Qty_Ordered and using a layout in the Line Items file I print out a Picking Ticket for the warehouse help. That all works like a charm, and I couldn't be happier. However, after an order is picked, I have another layout in the Invoice file where I can update the Qty_Packed field in in the Line Items file and generate an invoice. What I want is to also be able to update the item's status field in the Inventory file using this same layout. For example, a pick ticket may come back with an item marked out of stock, or back-ordered, etc. I want to be able to change related data in the Inventory and the Line Item files as I am preparing an invoice... can it be done?