Background: I have designed a solution for Filemaker to input data into a Question Database.
After we are done with inputting data into Filemaker, we will be exporting the data as excel and transferring it into an online system probably running on ASP.NET or PHP
Part of it looks like this:
Knowledge Table: Knowledge ID (Primary Key), Description, Knowledge Type Method Table: Method ID (Primary Key), Step, Step Knowledge ID
For example. The "Find Acceleration method" Knowledge can have 3 steps:
- Find unknown velocity
- Find unknown time
- Apply acceleration formula
Each of these steps is also a record in the Knowledge Table, i.e., the steps are knowledges in Knowledge Table.
How do I model the double relationship between Knowledge Table and Method Knowledge Step Table?
Currently, I thought of 2 ways:
Knowledge Table::Knowledge ID -- Method Table::Method ID relationship AND Knowledge Table::Knowledge ID --< Method Table::Step Knowledge ID
Creating another instance of Knowledge Table and link the Knowledge ID separately to Method Table: Step Knowledge ID.
I'm really not too sure of what is the best way of doing it.