Jump to content

Join Table Clarification


sflynn
 Share

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

Recommended Posts

I have what may be a simple question. I have a pretty complicated dbase going and I have a bunch of Join tables connecting many-to-many relationships. They work fine. In addition to using the 3 fields I need in a join , Join id, Table1 id and table2 id I used a bunch of fields to do lookups to put data in the join table from the other two tables. I then used these fields in portals throughout the dbase... only problem (i learn now) is that they don't change when someone changes data in the first tables. Should I have just used the three primary fields in the join table...and then accessed the other data via relationships? is that best practice? Was there any reason I did what I did, or was it just inexperience?

Link to comment
Share on other sites

Thanks for the reply. I think I answered my own question. After some experimenting, I've realised that most of my lookups were redundant... but there were some fields in the join tables that were unique to the join record and those obviously belonged there.

thanks.

Link to comment
Share on other sites

This topic is 5763 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
 Share

×
×
  • Create New...

Important Information

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