2. I would appreciate some guidance on the following. I have a Customer Table, Product Table and Special Prices Table. The Special Prices will contain Special Prices for specific Customers for Specific products. So the structure of the Special Prices table , will contain 3 fields, Cus_Num, Prod_Num and Spec_price. I will want two forms, One where the Main Key will be the Customer , and I will need to see all the Special prices by Product for that customer. I also will need a screen which shows a Product Code, and all the customers who have a special price for that product. Both of these tables will be Maintenance and View tables.
Whats the best way to set up the Special prices table. In one case, it can be viewed as l a child table to the Customer, in the other as a Child table to the Product file
This recent thread may help with the Parent/Child issue
http://forum.strataframe.net/Topic16728-7-1.aspx
Cheers, Peter
I cant get past the first bit of my question..just to set up the Child Parameters on my BusinessObject. I have up Solution Explorer, click on Bus Object I want to set up as my Child Bus Obj, and right click and goto properties..all I see here is Advanced tab and Miscell Tab. If I bring upt he Business Object Mapper, I cant see any fields in there referring to Child Bus Object.
You should be double-clicking the BO which will open the designer (or right-click and select View Designer). It will then present you with the CRUD settings, relationship settings, etc.