normalizing a relationship

[dmaxj]

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]

A, E, S? It's hard to think in these terms. Do you have real field names you can give them?

[dmaxj]

table A can be called ASSOCIATES

field E can be called TYPE

field S can be called SUBTYPE

Thanks

[Ender]

Still not making sense. Try your question again with more descriptive wording.