RE: setting controlsource for 1:many objects in n-tier design

You would then have to code the updates manually, however, as they would be no

physical tie to the real table (like in a view), right? You could still use

the buffering I suppose with GETNEXTMODIFIED to determine what record to

update, and then dynamically generate the UPDATE SQL assuming the record has a

unique identifier for it=2E Seems like a lot of work, however=2E Perhaps I'm

making a mountain out of a mole-hill?

>>> "ahilton@usexpr=2Ecom" 06/04/01 02:11PM >>>

You can just use a temp cursor retrieving them as needed from your

upper-tier=2E

- AHilton

> Someone mentioned earlier about "why would you hardcode a

> controlsource" when

> designing an n-tier system=2E Now I can see the non-grid objects

> (txt,lbl,cbo,

> etc=2E) having a custom form property for a control source, but

> what would you

> do about 1:many items like grids? My guess is that you'd use a

> custom form

> property ARRAY to hold the values?

> Is anyone doing this now? (I'm guessing CharlieGC since he's using

> SCATTER/GATHER a lot instead of buffering=2E=2E=2E) ???

=20=

*****************************************************

Michael Babcock

KePRO, Inc

Tel: 717-564-8288

Fax: 717-564-4188

Internet Address: mbabcock@kepro=2Eorg

*****************************************************