Simple Relationship Problem

[mrhooper]

Hello,

I have what I thought would be a simple relationship task, that has me scratching my head.

One of the problems is I dont do this full time and so I get something to work, then get sidetracked and loose track of how it is working. Was hoping someone could point me towards some sort of tutorial on relationships, or something that would help me.

The database I am setting up is for two sets of stores. One is a clothing store, the other is a jewelry store. They all produce a magazine, and I am trying to use this to track production. What i have set up is contact table, a stores name table, a local editorial table and a national editorial table. I am trying to use another table as the main table and have portals to edit and navigate the data. For some reason, no matter how I set up the relationships, one set will work and the other will not, and vica versa. For example, If i select one of the jewelry store names it is supposed to display the editorial and contact info related to that store. It works, but then the clothing store does not.

Think maybe I have too many relationships or something.

[Tpaairman]

I'm a version behind you, but this should be the same. first things first - when you set up the relations, if you are using the same field in a table for more than one relation you need to create a second copy of that table in your relaions. So you will see the same table twice (or even more depening on your file) You will give each table it's own name in the relaions, however the actual table itself does not change.

So let's say you have one table called "Main", one called "Clothing" and one called "Jewlery". When you go to your relations page add the table "Main" twice and use one for "Jewlery" and one for "Clothing"

The second part is when you are working in your layouts with the fields make sure that you select the correct relation - if you are in the main layout working with fields pertaining to the jewlery side, it will screw it up if you select fields from the clothing relation.