I'm still trying to figure out if Caspio is the right solution for me; I'll appreciate if you might help with my "problem".
There are a lot of solutions if you are the supplier of the order management, but no solutions if you are the one who is ordering (which is my case since my department is procurement & logistics).
Here's a brief description of the tables and what I haven't been able to do:
There will be Suppliers, Projects, Materials and Orders tables. When I need a material, in a form, I'll select a Supplier from a dropdown, I'll select the Project from dropdown, I'll select the material with unit and unit prices from a dropdown. Enter a quantity manually. It will calculate the total price for one row. I'll have repetitive/different materials which means several rows. I'll need a total value of all items.
The problem is the repetitive rows. Repeating rows will mean new rows, which means new table/new order. However, it's a single order with many items made to a single supplier for me.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
efsan
Hi there.
I'm still trying to figure out if Caspio is the right solution for me; I'll appreciate if you might help with my "problem".
There are a lot of solutions if you are the supplier of the order management, but no solutions if you are the one who is ordering (which is my case since my department is procurement & logistics).
Here's a brief description of the tables and what I haven't been able to do:
There will be Suppliers, Projects, Materials and Orders tables. When I need a material, in a form, I'll select a Supplier from a dropdown, I'll select the Project from dropdown, I'll select the material with unit and unit prices from a dropdown. Enter a quantity manually. It will calculate the total price for one row. I'll have repetitive/different materials which means several rows. I'll need a total value of all items.
The problem is the repetitive rows. Repeating rows will mean new rows, which means new table/new order. However, it's a single order with many items made to a single supplier for me.
Hope, it's clear.
Any suggestions?
Best,
efsan
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.