Prev: How do i recover a database lost during compacting?
Next: Access 2007 Note table in date order, note form is not. What can I
From: DeDBlanK on 10 Dec 2009 11:51
OK, thanks in advance. I always screw this up so here it goes:

Three tables: Line, Part, LinetoPart
I could set these tables up differently, but Part A can be ran on
Line1, 2, or 3.
LinetoParts has autonumber pkLinetoPart, fkLine, and fkPart.
So how do I keep the many table from duplicating say an entry stating
that Part A to Line 1? Am I missing the boat here?
In the LinetoParts pkParts can duplicate and pkLine can duplicate, but
I don't want a duplicate record with the same pkPart and pkLine.
*Relationship Algebra why do you plague me so?*
From: Fred on 10 Dec 2009 13:41

At the nuts and bolts level, what you seek is a constraint on records in
your junction table, not on the relationships.

How about creating a 2 field (fkLine, fkPart) index in your junciton table
set to "unique"?


 | 
Pages: 1
Prev: How do i recover a database lost during compacting?
Next: Access 2007 Note table in date order, note form is not. What can I