As an Alpha 4 user since the early 90�s, all my applications have been based on the DOS versions thru Alaha4v8. I tried Alpha5 early on, and didn�t like it. Now, I feel it is necessary to make the switch and my company has bought Alpha5v10, Runtime, and the Web Developer packages.
I have started to convert the many things we developed with A4v8, and have just run into my first problem. I have 2 tables called Inventory and MasterList. Inventory is our Company list of items in stock���qty, description, prices, etc. This is indexed by a �part number� index. MasterList is the aggregation of all the parts price lists our main vendor has issued annually each year. This is also indexed by �part number�. In A4v8,
MasterList is linked to Inventory where MasterList is a look up table. Our form view has all the data showing from both tables.
If we buy some parts from a dealer who is going out of business, we type the part number into the Inventory part number field, and if the part is already in our inventory, we just add the quantity to that record. If the part is not in our inventory, it should be found in the MasterList look up table and all the data could be transferred to the Inventory table. It works great in A4v8 and all our employees are happy with the way it works.
But, I can�t get it to work the same way in A5v10. When I do a search by part number, it searches the MasterList table not the Inventory table as in A4v8.
Any comments or suggestions will be appreciated.
I have started to convert the many things we developed with A4v8, and have just run into my first problem. I have 2 tables called Inventory and MasterList. Inventory is our Company list of items in stock���qty, description, prices, etc. This is indexed by a �part number� index. MasterList is the aggregation of all the parts price lists our main vendor has issued annually each year. This is also indexed by �part number�. In A4v8,
MasterList is linked to Inventory where MasterList is a look up table. Our form view has all the data showing from both tables.
If we buy some parts from a dealer who is going out of business, we type the part number into the Inventory part number field, and if the part is already in our inventory, we just add the quantity to that record. If the part is not in our inventory, it should be found in the MasterList look up table and all the data could be transferred to the Inventory table. It works great in A4v8 and all our employees are happy with the way it works.
But, I can�t get it to work the same way in A5v10. When I do a search by part number, it searches the MasterList table not the Inventory table as in A4v8.
Any comments or suggestions will be appreciated.
Comment