Fill Drop-Down With Query

[FlyBoy]

Using FP2003 on XPPro, site hosted on WIN2000 Server, IIS6, Access 2003
database.

Is there any way to fill the selections of a drop-down box from a query?
I'm writing an application that has 40+ entry forms, each of which uses a
drop-down. I can't see any way of filling the values with a query, and
entering them individually will become an administrative nightmare.

Thanks

 

[Jeff Metcalf]

Sure, you can insert a database results region inside your form. But the
code will get pretty big, pretty quick if you're not carefull.

Look here http://www.outfront.net/spooky/adv_drw.htm to take out all the
extra code FP uses that you don't need.

HTH

 

[FlyBoy]

Thanks Jeff!

That's an approach I never would have thought of. It was a very elegant
solution.