I am defining a form in correspondance with its table. It means hat the fiel data of the form are those of the table.This tableand form are called "orders".
The forms fields are classified in two groups:
-the first group it is the identification of a set of products and basic attributes such as ,size, large,height dimensions ,unit volume, and unit price . The products are grouped by categories that also have their own code identification. All this infrmation is registered and stored in another different table called "categories and products".
-the second group it is the number of units that a buyer wants to order of one product ,plus calculation fields as the total price = unit price x number of units, the total volume=unit volume xnumber of units ,and total weight as=.
The first field of the form to be filled it is a drop-down field where the user select the category product code he wants.
after this i have 3 questions to solve:
1?) How can i display the identifcation of all the products belonging to this category joint to all the basic attributes, getting the information from the table "category an products" ,line, by line, avoiding the user to type information already stored?
EXample,after the user select the category fruits, it should be displaied automaticlly :
*apple_code ,apple_unit_large,apple_unit_side, apple_unit_height,apple_unit_ weight,apple_unit_price.
*orange_code,orange_unit_large,orange_unit_side, orange_unit_height, orange_unit_volume,orange unit_weight,orange_unit_price.
-------
*banana...
Line by line.
2?) How can I add , line by line, the fields number of units and the calculated fields, total weight,toal volumen and total price.
3?) how and where can I defined the format fo the form as a table format?
Thank you for your help,
and early response will be highly appreciated
radvla
The forms fields are classified in two groups:
-the first group it is the identification of a set of products and basic attributes such as ,size, large,height dimensions ,unit volume, and unit price . The products are grouped by categories that also have their own code identification. All this infrmation is registered and stored in another different table called "categories and products".
-the second group it is the number of units that a buyer wants to order of one product ,plus calculation fields as the total price = unit price x number of units, the total volume=unit volume xnumber of units ,and total weight as=.
The first field of the form to be filled it is a drop-down field where the user select the category product code he wants.
after this i have 3 questions to solve:
1?) How can i display the identifcation of all the products belonging to this category joint to all the basic attributes, getting the information from the table "category an products" ,line, by line, avoiding the user to type information already stored?
EXample,after the user select the category fruits, it should be displaied automaticlly :
*apple_code ,apple_unit_large,apple_unit_side, apple_unit_height,apple_unit_ weight,apple_unit_price.
*orange_code,orange_unit_large,orange_unit_side, orange_unit_height, orange_unit_volume,orange unit_weight,orange_unit_price.
-------
*banana...
Line by line.
2?) How can I add , line by line, the fields number of units and the calculated fields, total weight,toal volumen and total price.
3?) how and where can I defined the format fo the form as a table format?
Thank you for your help,
and early response will be highly appreciated
radvla