Topic: Master Detail form
Hello,
I am working on a application so the user can place an order with the suppliers for parts required. There is a form which is added per order and the form has an auto increment number which gives the Track number and this is the master. There is a Items table which has fields for TrackNumber, Quantity, PartNumber, Description, and Price. I place a TableGrid at the bottom of the master form and set it to display the fields from the Items table. This TableGrid is set so that it has AllowEdit and AllowCreate so the user can just enter the items required.
The user should be able to add items to the table and each line item record should have the Track number added so each master record has the correct line items. I would really like to display the quantity*unit price at the right hand end of each line and the sum at the bottom of the table.
I am having trouble getting this to work. Can anybody help please?
Thanks in advance,
David