Linking Order Results to Order Details??
Hi Ray et al,
I have created a shopping cart (with Excellent help from Dani and support!!!! thanks guys )
Using the eCart Sample databases as my template I have created the Orders and OrderDetails mysql tables which are populated automatically by the cart...
I created an Admin ability using Data Wizard to search the Orders but I don't want to duplicate all these pages (results, details, updates, etc) in order to link the Orders (which has info on the customer but NO info on the items ordered) to the Order Details (which has the details of the item cart but no details on the customer).
In other words, OrderRefernceID and the DetailsReferenceID are the same number but what is the strategy for linking these results? I expect that when the admin wants to look up an order for a client, e.g., she will want to have the results of the cart contents and the info on the customer on the same page... I don't even see a way of taking the reference id and linking them in DA...
In a similar vein, I think I want customers to be able to view a subset of the information if they type in a reference ID and their email...
So is there a tutorial for this solution? I could use the wizard to create details pages, and although I tried just using the search wizard, it is kicking back mysql errors if I try to add the behavior to the existing Orders pages...
Thanks,
Jeff