thanks for the reply,
ranking maybe not the correct word but here is an example:
We have a customer database and each Customer is assigned 3 sales reps.
Each sales rep is either Primary, Secondary or Third responsible
Solution 1:
On the Customer BO, create three Attributes which are SalesRep1, SalesRep2, SalesRep3 which are all relations to another BO called Employees.
This is the current way we do it but its messy feeling as we have to have
more of the forms space used.
Solution Prefered
On the Customer BO, create one Attribute called SalesReps - allow edit as a grid - and SOMEHOW allow a drop down to Assign each Choosen rep as Primary, Secondary and Third
Does this make more sense?