Need a duplicate value to appear

[mare]

I have a database that controls what projects we are working on and what documents are tied up to that particular project. Each document has a 5-digit stock number for ordering (a number for English, and a number for French). These numbers are unique to each document (no duplicates allowed).

Here's my problem...

I have a new project that contains 4 documents, 3 of which have their unique stock numbers for ordering. The 4th document is already in use with a previous project and it didn't make sense to have the exact same document with 2 different stock numbers. When I run the reports by Project, how can I get this 1 particular document to appear in the reports for both projects?

Any help will be appreciated.

P.S.: I'm using XP.

Thank you.

 

[mark curtis]

without looking at the db and table structure I think that you need to change the integrity of the tables. Either only one project can only have any one document (no duplicates allowed) Or change the rules to allow duplicates.

 

[mare]

Mark, unfortunately, because the document is the same in both project, it didn't make sense to have 2 different stock numbers for the same document (let's not confuse more people than we have to).

How do you change the rules to allow duplicates?

Thank you.

 

[Pat Hartman]

Your table sounds like it has a one-field primary key (StockNumber) and you need a two-field primary key (StockNumber and ProjectNumber).

Open the table in design view.
Select BOTH columns.
Click the lightning bolt icon to create/change the pk.