Okay Bob now it looks like I can add new records. However, with the first statement SELECT Clients.*, [Attachment].FileName FROM Clients; I have 69 records and now I only have 53.
Okay Bob now it looks like I can add new records. However, with the first statement SELECT Clients.*, [Attachment].FileName FROM Clients; I have 69 records and now I only have 53.
Yep, and that is because you have more than one attachment for some records. The * will include the attachment field properly so that you can add/delete, etc. from that field. The only time you want to use Attachment.FileName is when you have a query for a Report or some other query which you do not need to have it be updateable.