If the data in the lookup's is static, I'd connect a TClientDataSet to a TDataSetProvieder which connects to your table. This will mean that you only open the tables briefly.
Alister Christie Computers for People Ph: 04 471 1849 Fax: 04 471 1266 http://www.salespartner.co.nz Follow us on Twitter http://twitter.com/salespartner PO Box 13085 Johnsonville Wellington On 12/02/2012 12:21 a.m., Charlie wrote: > I'm using CodeGear 2007 with dBase tables. > On my order form which is actually on two tabsheets (one has fields > which are for the order table and the second tabsheet has fields which > are for the order detail table) I have several TDBLookupCombo controls. > For the lookup to occur the lookup table has to be 'not closed'. > The 'order' form is called from the program's main form. > My question is should I open these tables when the order form is created > or open these tables when either of the tabsheets are clicked on? > Secondly, when and how should these tables be closed? > Thank you, > Charlie > _______________________________________________ > NZ Borland Developers Group - Delphi mailing list > Post: [email protected] > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to [email protected] with > Subject: unsubscribe > > _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
