Show clone = false... for Linked subform

[Greyowlsl]

Hi,

Overview:
Ok so i have document database, and i have a number of forms these forms have a tab control layout on them. There is a 'Search' tab, a 'Add' tab, and a 'Edit' tab. Now what i have is a edit log table linked with the documents table on two seperate subforms on the 'Search' page. They are linked by the 'Document Number' which is not the primary key. The 'Add' page is linked to the document subform and the 'Edit' page is linked to the Log subform.

Aim:
My aim is to have a changes log for each document so that when i select a document in the document subform that the all the changes made to that document are shown on the log subform.

Problem:
When i open the 'Search' tab there are somtimes more than one record with the same 'document number' in the log subform. This is normal as users may update the same document more than once causing there to be 2 or more of the same document number listed under the log subform; but... this also causes the document subform to display a duplicate of the document with that 'document number'.

Proposed Solution:
I dont know if there is a way but i was wondering if there is a piece of code that will automaticly hide any records that have the same document number on the document subform. Or if there is a better way please tell me.



Thanks for taking the time to read this, i hope i havent wasted your time by asking a simple and stupid question.

,Leon

 

[Niniel]

You can set a query property so that only unique data is shown, have you tried that yet?
I believe there are 2 different versions - Unique Record, where the entire record has to be unique - and Unique Values, that doesn't look at the entire record.
Unless you've tried this already, I suggest you take a look at that.

This may or may not work, and there may be a way to do this better and in code, but this is all I can think of right now.

Sorry.

 

[Greyowlsl]

Hey

yea i have tried that and it doesnt work, even if it did i have two tables in the query and i only want one table to have unique records, basicly i need a 1 to many relationship with tables.

thanks for trying to help tho

,Leon

 

[Greyowlsl]

This is basicly what i need:
Before
After