Hello,
I have a many to many relationship between tables Platform and Comms. I accomplish this with a junction table, LI_PlatComm. I want to know, using the communication systems, which platforms can talk to each other. A comm system can talk to itself and some are compatible with other systems. I created the table, Compatible, which is a list of communication systems that can talk. Aka it has field kf_comm (a specific communication system's key) and field kf_compatiblecomm (key to the comm system it can talk to).
My relationship table looks like Platform TO LI_PlatComm TO Comms. How do I incorporate Compatible? Does Access allow duplicate table occurances in the realtionship graph? If yes, then I could do Platform TO LI_PlatComm To Compatible (using kf_comm) TO LI_PlatComm Duplicate (using kf_compatiblecomm) TO Platform Duplicate. Other database software allows this but when I tried it in Access it didn't appear to be working as desired. Also I've seen no mention of duplicate table occurances in my reference book. I could probably remove the need for Compatible table by creating a multi-value field in Comm table that lists the keys of all compatible communication systems. But I will still need a duplicate of LI_PlatComm.
Any ideas on how to set up this relationship? Or ideas on another technique to get the data I need?
Thanks