Hi. I am trying to build an Access database. I have a table called "Customers" and a table called "Subsidiaries." Each customer has a unique ID associated with it, a field called Customer_ID. There are some customers that have no Subsidiaries. There are some Customers that have more...

MS Access help gives clear steps to create clustered index. I need to create clustered index using SQL statements how do i do that? I get syntax error near the keyword "Clustered". Same statement is working in MS SQL 2000. CREATE CLUSTERED INDEX Sample_Clus_Index ON dbo.SampleTable(Id, Name...

I'm dong MS Access Programming , I want to display some items in the combo box , and I don't know how to do it exactly . I want to add items from database that is I want to bind a record set with combo box .I have two fields here Name and Code . I want to display the name in the list and set...