|
T
|
trek46 2/7/2011 |
|
You should go to the customers page first and search and add if needed. After you found them or added them click the products link in in the customers list page. Depending on how you have your tables relationships set when you add new the (customers)id should automatically be selected. As for the firstname and lastname you can add the customers table to the query for products. Just make sure they are read-only as you won't be able to save the record. I am a new user to Phprunner. I have a question I have two tables Master table: customers (lastname, firstname, id, address, phone, etc) detailed table: products (lastname, firstname, id, item, price, etc) I run Phprunner' application wizard and generated my application. What I want is to copy lastname, firstname, id from customers to products: when adding new records in products, after I click ADD NEW, I do not want to open blank form of products immediately. I need to open customers first, I can search and select a customer from customers table. After I select what I want, open blank form of products, and automatically fill lastname, firstname, id in products form. Then I can input the rest of data. This way, I can avoid input errors for lastname, firstname, id. Thanks Crosstab |
|