dmaxj Posted April 7, 2004 Posted April 7, 2004 I am trying to reduce a relationship from an inherited database. I think I have an idea, but I wanted to see what others thought. I have table A, with two fields. The fields are E and S [A:E and A:S]. Field E has redundant names. Field S is dependent on field E, meaning that I can't have S without E. As it stands now, each record is composed of a single E and a single S. Therefore, i could say that the combination of E and S give me a primary key. Would it be wise to break the E field into its own table (forcing a new Primiary key) and creating new tables for S. I assume that this would mean that I would have to make new relationships for S. But, I would reduce the current one table. An I making sense? FileMaker Version: 6 Platform: Windows XP
Ender Posted April 7, 2004 Posted April 7, 2004 A, E, S? It's hard to think in these terms. Do you have real field names you can give them?
dmaxj Posted April 7, 2004 Author Posted April 7, 2004 table A can be called ASSOCIATES field E can be called TYPE field S can be called SUBTYPE Thanks
Ender Posted April 8, 2004 Posted April 8, 2004 Still not making sense. Try your question again with more descriptive wording.
Recommended Posts
This topic is 7632 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now