Thank you ChazMan - very effective.

Thank you. Using a PIN (Personal Id Number) as a primary key.

Many, many thanks ChazMan. Your information is appreciated

JS

Mr. Jones,

There are a total of 6 tables and 2 databases. I have 4 tables in my database. I have access to the other 2 tables in another database. The...

Hi,

I'll have to reply on Monday. The db is at my place of work and I'm snowed in for the weekend.

Thank you very much.

John

Thank you. Will do.

Again, thank you.

Thanks for the information. Currently I am not using a PK because it is not necessary. I may change that later. I will try the IF Exists() approach for the...

Perfect! Thank you very much

Mr. Wilhoite,

Wow! Thank you very much. I did the following and it works fine.

SelectCommand="SELECT Project + ' - ' + Task + ' - ' + Iif(isnull(SubTask),' (No Sub Task)...

Mr. Moden,

Thank you very much. I did the following.

SelectCommand="SELECT Project + ' - ' + Task + ' - ' + Iif(isnull(SubTask),' (No Sub Task) ',SubTask) + ' - '...

Ms. Pettis,

Thank you very much for your reply. I did the following and it works fine.

SelectCommand="SELECT Project + ' - ' + Task + ' - ' + Iif(isnull(SubTask),' (No...

Mr. Wilhoite,

Thank you for your response. The Sub Task column also has content in some rows and nothing in others. I tried your suggestion of SelectCommand="SELECT Project + ' '...