From what I learn in doing a dataset with lookup, I do this


select m.last, m.first, m.last,
(select field1 from type1 d where d.id=m.type1) as type1,
(select field1 from type2 d where d.id=m.type2) as type2,
(select field1 from type3 d where d.id=m.type3) as type3,
from customer m


then after that i will have 3 ib_query for the lookup list and
properly set it up with the ib_lookupcombo


my question are

1. what if I have more than 5 lookup list? will that kind of setup be
slow?
2. having many lookup list takes a lot of time to set it up? do we
have other way?
3. what are the limitation and things to avoid in this kind of setup?


thanks