This topic is locked

table editing

8/3/2005 8:17:51 PM
ASPRunnerPro General questions
C
citronontherox author

Hi,
So, from reading posts I gather that it is not possible to edit fields from multiple database tables from one ADD/EDIT screen that ASPRunner generates?
For example, I have an Orders table that is linked to OrderDetails (and then Products), Employees and Customers. When someone wants to add a new order, I can't seem to make it possible for selection of product to make changes in the database so that it is shown on the other tables. If I ADD a Product, I'd like to be able to have a customer order it and then the quantity on hand to be changed in the Products table, etc, etc. Is this not possible?

Sergey Kornilov admin 8/4/2005

Hi,
yes is not possible to edit fields from multiple database tables from one ADD/EDIT screen.
You can set Orders table as Master table for OrderDetails table. Add new order then open order details and edit them.