dmaxj Posted April 7, 2004 Share 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 Link to comment Share on other sites More sharing options...
Ender Posted April 7, 2004 Share 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? Link to comment Share on other sites More sharing options...
dmaxj Posted April 7, 2004 Author Share Posted April 7, 2004 table A can be called ASSOCIATES field E can be called TYPE field S can be called SUBTYPE Thanks Link to comment Share on other sites More sharing options...
Ender Posted April 8, 2004 Share Posted April 8, 2004 Still not making sense. Try your question again with more descriptive wording. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7315 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