I'm not sure how to get started with this.
I have been using A5 about a year. Have made a few working db's.
I am not a programmer, but would like to learn and have learned a lot from this forum. I learn a lot just trying to convey my problem/question.
Many times I have found my answer merely by typing out my question.
I am not a beginner beginner. I know how to make sets, queries, reports, lookups. Put buttons on forms. I use the genies. Code I don't have a grasp on that. Have copied some from help and modified a little to work in my db's.
I use Quickbooks for my accounting, invoicing, sales orders, but it lacking in customizing to fit my needs. I export to Excel, then import to A5. A5 has been a big help in managing my data. I tried the QODBC but it is way too complicated! I imported tables, tried some SQL queries. I even did an ADO operation to changed data in Quickbooks, but it is easier to export to Excel and import to A5 than to try to automate that with QODBC.
I am looking for some general direction on how to set up this type of db (SO/WIP).
We receive several SO's a day with several different items.
So I need a report/WO (Work Order) to show all of the items needed.
Next, there may be 3 to 4 operations/phases for each item. Then at the end of the day, I need to enter what quantity was completed for that operation.
Tomorrow I need a WO showing what is needed, less what was completed, plus new SO's.
I have made the SO set, header table and detail table, with a 1 to many relationship. Now I am stuck. How do I post the Date, SO number, Customer, and the details of the order? To what kind of table and/or set?
I have an understanding on how to post in field rules and the post operation.
Now in reading my own question, it looks like I need to post the quantity to the item table, instead of trying to tie it to the customer. Then when I have the Items complete, pull from Item inventory table to fill Sales Orders.
But I still don't know how to "Post" from a 1 to many set.
I guess I would need an item inventory table for each operation/phase?
Any thoughts on how to get started with this would be greatly appreciated!
I have been using A5 about a year. Have made a few working db's.
I am not a programmer, but would like to learn and have learned a lot from this forum. I learn a lot just trying to convey my problem/question.
Many times I have found my answer merely by typing out my question.
I am not a beginner beginner. I know how to make sets, queries, reports, lookups. Put buttons on forms. I use the genies. Code I don't have a grasp on that. Have copied some from help and modified a little to work in my db's.
I use Quickbooks for my accounting, invoicing, sales orders, but it lacking in customizing to fit my needs. I export to Excel, then import to A5. A5 has been a big help in managing my data. I tried the QODBC but it is way too complicated! I imported tables, tried some SQL queries. I even did an ADO operation to changed data in Quickbooks, but it is easier to export to Excel and import to A5 than to try to automate that with QODBC.
I am looking for some general direction on how to set up this type of db (SO/WIP).
We receive several SO's a day with several different items.
So I need a report/WO (Work Order) to show all of the items needed.
Next, there may be 3 to 4 operations/phases for each item. Then at the end of the day, I need to enter what quantity was completed for that operation.
Tomorrow I need a WO showing what is needed, less what was completed, plus new SO's.
I have made the SO set, header table and detail table, with a 1 to many relationship. Now I am stuck. How do I post the Date, SO number, Customer, and the details of the order? To what kind of table and/or set?
I have an understanding on how to post in field rules and the post operation.
Now in reading my own question, it looks like I need to post the quantity to the item table, instead of trying to tie it to the customer. Then when I have the Items complete, pull from Item inventory table to fill Sales Orders.
But I still don't know how to "Post" from a 1 to many set.
I guess I would need an item inventory table for each operation/phase?
Any thoughts on how to get started with this would be greatly appreciated!
Comment