Jump to content

In a relationship table, is it ok to use two foreign key of a combination ID to connect to each other?

Recommended Posts


I am trying to get the cost from a matrix table. My question is that is it ok to use combine ID using other table ID and use it as a link to connect to other table and get the cost from the matrix, instead of using primary key?  Like using a combination of foreign id key to make one unique key to connect to other table with the same key to get the data.   Is that ok?

If it is not conventional, what is a better proposal?  Many Thanks. 



matrix table.png

Text Matrix.fmp12

Edited by Spidey
Link to post
Share on other sites

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.