If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cross References Help
I'm sure this question has an easy answer. Just can't figure it out on my own.
How do I design a situation where I can have multiple cross-references created for my records? My current setup: tblResources -ResourceID -ResourceText tblCrossReferences -ParentResourceID -ChildResourceID I have a many to many relationship. But here is where it falls apart. If I am on record 1 and I create cross references to records 2, 3, and 4 in the cross references subform, then I navigate on the main form to record 2, I want to be able to see the cross reference linking records 1 and 2. But since the sfrmCrossReferences is linked to the ParentResourceID, it doesn't show that these two resources have been linked when I am on record 2. Is there a way to show this? Any help would sure be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|