<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<br><br><div><div id="SkyDrivePlaceholder"></div>> I'm using CodeGear 2007 with dBase tables.<br>> On my order form which is actually on two tabsheets (one has fields <br>> which are for the order table and the second tabsheet has fields which <br>> are for the order detail table) I have several TDBLookupCombo controls. <br>> For the lookup to occur the lookup table has to be 'not closed'.<br>> The 'order' form is called from the program's main form.<br>> My question is should I open these tables when the order form is created <br>> or open these tables when either of the tabsheets are clicked on?<br>> Secondly, when and how should these tables be closed?<br><br></div><div>when you have data for lookups, you should keep these datasets active, as you probably will use these same data again. This will minimize network traffic, server load, etc...</div><div><br></div><div>For these cases, the best solution is to use ClientDatasets, as you can load the data in the ClientDataset and disconnect from the database, keeping the data on the local memory.</div><div><br></div><div>read this: <a href="http://www.drbob42.com/examines/examin64.htm" style="font-size: 10pt; ">http://www.drbob42.com/examines/examin64.htm</a> and also search for "briefcase model ClientDataset" on google.</div><div><br></div><div>--</div><div>Jackson</div> </div></body>
</html>