You need to sign in to do that
Don't have an account?
jagjitsingh@indivar.com
Pages
Hi
I have following fields
Order_no , Order_date , Customer Name(Lookup Field) , Product Code , Quantity , Value .
Should i create 1 table or should i create Master-Detail relationship. Product Code , Quantity , Value can be multiple in 1 Order .
Thanks
According to 1NF, you should order your data such that there is no duplication of data. Thus, you should have two objects, one that the describes the order itself (order number, order date, customer name), and the other that describes the line items (product code, quantity, value). This would be the recommended approach of database design.
All Answers
According to 1NF, you should order your data such that there is no duplication of data. Thus, you should have two objects, one that the describes the order itself (order number, order date, customer name), and the other that describes the line items (product code, quantity, value). This would be the recommended approach of database design.
Hi SFDCFox
That is accepted . Now i want to create a page like this
Order no : Order Date : Customer Name:
Product no Quantity Value
Delete Button Pr1 5 100
Add New Row
When user clicks on Add New Row , another row will be added and user will be able to add another Line Items.
Then there should be Save Button when user clicks on this Data is added in both the tables.
I will be very thankful to u , if u can provide help with Page & code on this.
Thanks