Posted on 2004-09-29
Have two forms. in the first form named 'Client' i've a numeric field called Client ID and address information details (like address1, address2, city, state, zip, zip-ex etc).
Now I've another form 'Clientnumbers'. I've two fields in this form. First field is the Client ID and the second field is Client numbers (cnum) a multi-value field.
Cnum can contain values upto 100.
Now lets say I've a 'Cleint' form which has the Client ID as MCI100 and the address information details.
Now I've a 'Clientnumbers' form which has Client ID as MCI100 and all the Client numbers in it.
The requirement is I've to show a view which will show all the Client numbers in the first column from Clientnumbers form and the address details from 'Client' form in the other columns.
I've to join the ClientID to source.
basically the first column in from Clientnumbers form. and the other columns are from Client form.