Distinct command not working

[RuralGuy]

We're just going around in circles here. Can you post a stripped down version of the db with any sensitive data removed? You need to leave enough sample data to demonstrate the issue. I don't have ac97 so I'll have to bump your db to ac2k format to test it.

 

[Greyowlsl]

Hey, ive sent the database to your msn email, in an attachment.

 

[RuralGuy]

It's here. I'll look at it and get back to you.

 

[Greyowlsl]

Ok thanks

 

[RuralGuy]

I gave the Drawings table a Primary key and the DISTINCT started working. By the way, if you Compact and Repair you can shrink the db down quite a bit.

 

[Greyowlsl]

Hi again,

Ok so here is what happend when i opened the dd you changed.

- I went to open 'TheForm' and the OLE hyperlink error came up again.
So i removed the hyperlink field from the 'TEST2' query.

- This worked and made the datasubform hide any duplicates, but the logsubform shows no records at all.

- When i open the Logtest form it shows the correct records, so i changed the record source on TheForm from TEST2 to TEST but nothing changed.

Maybe its somthing to do with the child and master fields, but i cant change them because the forms are unbound.

 

[RuralGuy]

In acXP I never receive your HyperLink error but I removed the field so you won't get the error in ac97. I had not included the Log fields in the Test2 query so I put them in. I'm not sure what you want TheForm to accomplish so that's all I did.

 

[Greyowlsl]

Ok well basicly i want it so that when i select a record in the datasubform it will show all the edits made to that document on the log form, this is to keep the user updated on the document they are looking for.

Example: I select a record from the datasubform and that record has a document number called 'F14', now that the document is selected a list of all the changes made to the F14 document are displayed on the log subform.

On the other tabs you can add a document to the drawings table and on the edit table you can add a changes record for that document to the log table.