I was just handed Alpha5 last week and asked to build a few web pages to allow our users to track the sale of money orders, gift cards, etc... I'm familiar with relational databases, but not the how-to of Alpha5. This seems like a basic thing to implement, but any help would be greatly appreciated.
At the start, I have 5 tables: Customers, MoneyOrders, TravelerCheck, CashierCheck and GiftCards. In the Customers table, I have basic customer fields as well as a CustID field that is set to auto-increment. In all the other tables, I have fields pertaining to the order, an ID field set to auto-increment and a CustomerID field.
In the desktop application, I created a form to enter travelers checks that contains check info and customer info from the respective tables. This form uses a set that consists of the customer & travelercheck tables in a one-to-many relationship, linked using the customerid field from the travelercheck table and the CustID field from the customers table. From this form, I can enter new travelerscheck and corresponding customer information. A new record is created in the travelerscheck and customer table, with the CustID of the newly created Customer record also appearing in the CustomerID field of the newly created TravelerCheck record - the way it should work.
I am now trying to do this same thing using a web application, so many users can have access to these pages. I've tried to just create an updateable grid component using a view that contains the travelercheck and customer tables, linked using the CustomerID field from travelercheck table and CustID field from Customers table. Add this component to an a5w page, input data and a new record is created in travelercheck table and a new record is created in the customer table, but the CustomerID field in the newly created travelercheck record is 0, not the CustID of the newly created Customer record. I've looked all through the Help contents, and I believe the grid components are structured to work with one-to-one relationships?? I've looked at gridlinker components, but not sure if this will work for what we're needing to do?? Any ideas on how I can go about creating a component that allows users to insert new data and act like the form created in the desktop app?
At the start, I have 5 tables: Customers, MoneyOrders, TravelerCheck, CashierCheck and GiftCards. In the Customers table, I have basic customer fields as well as a CustID field that is set to auto-increment. In all the other tables, I have fields pertaining to the order, an ID field set to auto-increment and a CustomerID field.
In the desktop application, I created a form to enter travelers checks that contains check info and customer info from the respective tables. This form uses a set that consists of the customer & travelercheck tables in a one-to-many relationship, linked using the customerid field from the travelercheck table and the CustID field from the customers table. From this form, I can enter new travelerscheck and corresponding customer information. A new record is created in the travelerscheck and customer table, with the CustID of the newly created Customer record also appearing in the CustomerID field of the newly created TravelerCheck record - the way it should work.
I am now trying to do this same thing using a web application, so many users can have access to these pages. I've tried to just create an updateable grid component using a view that contains the travelercheck and customer tables, linked using the CustomerID field from travelercheck table and CustID field from Customers table. Add this component to an a5w page, input data and a new record is created in travelercheck table and a new record is created in the customer table, but the CustomerID field in the newly created travelercheck record is 0, not the CustID of the newly created Customer record. I've looked all through the Help contents, and I believe the grid components are structured to work with one-to-one relationships?? I've looked at gridlinker components, but not sure if this will work for what we're needing to do?? Any ideas on how I can go about creating a component that allows users to insert new data and act like the form created in the desktop app?
Comment