Hi Ed, Thanks for responding. Sorry I was not able to explain better the first time round, I'll try again differently.
I have an Items master. This is a part explosion thing. The table in wich I am storing the part details is also the same table in which I define the sub-assemblies. So to connect a part (and its used qty.) to sub-assm I have to use the same table to get the connection of the sub-assm. in which it is contained. So on till the finished assemblies are entered. In essence it is the same table into which I am data entering and also calling on the same table for a connection.
This or any suggesstion for practically getting this thing up and running.
Thanks again for responding, I would like to put in personally that you & YAG and all others in the CB project have helped the VFP community in a very remarkable way.
<i><font color="#663300"><i><font color="#663300">For a Hierarchyal data representation I want the Primary BizObj of the Form to also become the lookup for the same Form (I do not mind to create a second BizObj of the same table). Is it possible? Please advise.</font></i>
I'm not sure what you need exactly. Do you mean that you want the user to be able to search for a particular record from your primary bizobj? If so, that's exactly what the primary bizobj on the form is supposed to be used for. Just set the view parameter for the bizobj's view to the value entered by the user, and call Requery(). This will update the bizobj with the selected records. </font></i>
Regards Bhavbhuti ©2001 Bhavbhuti Nathwani |