Jump to content

This topic is 7632 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.