Please help...

[MattTaylor]

In my database I have 4 sections...Sales, Service, Inventory and Contacts...everything works but one thing..

On my service and sales orders there is an area for "Product Quantity" (how many purchased or used)...when I input a quantity, I need it to pull that number from my "Amount in Stock" from my Inventory section.

If this makes sense and you have a solution, please help. Thanks a lot.

- Matt

[Razumovsky]

HI Matt, welcome!

Inventory management is a hot topic around here, and there are many posts on the subject with different approaches. Try running a search for "Inventory." Here is one to get you started.

-Raz

[T-Square]

everything works but one thing..

Dude, what's your secret? Only ONE problem!?!

David

[Ender]

Welcome Matt,

If you need to reduce the available inventory each time an order is processed, you might check out this rather interesting, and in-depth discussion from a few months ago:

http://fmforums.com/forum/showtopic.php?tid/171928

[MattTaylor]

Thanks very much Ender...this is extremely helpful to me.

- Matt

[MattTaylor]

Ok..apparently I'm still not doing something right....

Here are the two files I'm working with...please take a look and see what can be done.

Goal: When I enter a "Product Quantity" on my "Service Order"...I need it to pull that quantity from my "Inventory"...I can do it manually...but I would like the process to be automated...I know filemaker can do it...I just dont know the way...

Thanks!

Service_Orders_Clone.zip

bps_Inventory_Clone.zip

[Ender]

Well, Matt,

I don't know which method you're attempting and you haven't supplied an account/password to examine your files, so it's difficult to offer any advice.

[MattTaylor]

Sorry bout that...I forgot about the password...

user - dean

pass - 2129

And the method I tried was creating a relationship between Service and Inventory...currently Service is doing a "lookup" from Inventory to supply the "Amt in stock"...

Im really new at FM...I know I need it to pull out the "Qty" from Inventory...just not sure how...

- Matt

[Ender]

I see. It's unfortunate, but the template you've found lacks a basic relational structure. With your current structure, it would be very difficult to get those stock amounts that your looking for.

The main problem is with the way the service parts line items fields are defined. Your template has these line items as repeating field entries. A better structure would be a Line Item table that has fields for Product#, Product Description, Qty, Price, Price Extended, etc. This would then be related to Orders by a OrderID field and related to Product (Inventory) by Product#.

This is the basic structure that I was talking about in that previous referred to thread.