Jump to content

Please help...


MattTaylor
 Share

This topic is 5737 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5737 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.