Re: Many to Many Table Linking Architecture
Posted by: Frank Thomson
Date: October 19, 2013 07:43PM

If this is clumsy, I would be curious as to what the alternative is...

Hence my question in the first place.

The "real problem" is pretty much as described
I have a MRP (Manufacturing Resourse Planning) system that has a number of tables
Parts - List of basic parts decriptions
Documents - a list of the documents.
Purchase Orders
Invoices
Jobs
Quality Issues and problems
and so on. There are lots of these tables.

At present we have a dedicated table that links parts with drawings so we know what drawings are required to build a particular part and of course for a particular drawing what parts are affected if that drawing is changed.

We also have another dedicated table that links jobs to quality issues

And there are a few more of these dedicated linkages.

What I want to do is be able to link anything to anything (within reason of course)

So in essence a row in one table linked to a row in another table.

I am sure that this kind of issue is ver common and that there are ways that are better than others for implementing it.

Over to you for suggestions.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Re: Many to Many Table Linking Architecture
October 19, 2013 07:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.