Thank you for your reply. 

Thank you, for the information.

Its just an example.  I created the foreign key thru the interface.

Ok.  I know when you setup a database for backup one specifies for how long to retain the files before they are deleted.  I need to find out for how...

Thank you for the information.

Thanks, I will read through the articles.

It will be in every aspect of administration. Any suggestion helps.

Thanks, this helps.

Thank you, I will give it a try.

You were right, forgot to remove it.  Thank you so much for all your help.

Thanks I was able to figure it out.  One more question, I made more duplicate entries on purpose.  When I run the select * from test it only returns 7...

That's much better. I was able to order by Company.  How can I also order by date and unit?

I'm not very good at queries. I appreciate your patience.

When I run this:

SELECT DISTINCT COMPANY

FROM Test

It returns only one hit, shouldn't it be returning more than one.

Thanks.

I gave it a try but, it quite does not return everything I need.  I need for it to return all the rows with the same duplicate.

Thanks, I'll give it a try.