Tracking References and Definitions

Welcome to Quickbase.  All things are possible.

There are two steps in getting this to work. The first step is to get the relationships and table set up correctly. And then the second step will be to make it easier for you to get the data entered. So first things first. 

Do you have a situation where one Document has many Document  Terms, but also of course, one particular standard document term is going to be used on many documents.  

So what we do is we set up a Many to Many relationship using a middle or so-called "join" table. We create a table called Document Terms.

so Documents < Document Terms > Standard Terms

ie

One Document has many Document Terms.

One Std Term has Many Document Terms.

The middle table that you will set up for this will initially have no fields. But when you set up the relationship he will look up the document name down into the document terms table and also look up the standard term from the terms table down into the Join table.

That will allow you to view a document and see an embedded report of all the document terms (ie a list of terms) and also will allow you to view a standard term record and see all the document terms (ie documents) it's used on.

When it comes to linking the documents, I gather you have a single table which holds all the documents but these documents are related to each other. But the same thing will hold no doubt, you will need a middle table called some thing like Document Usage. 

This can be a little confusing because the documents are related to them self. 

But you will make that middle table for Documnt Usage.

Then again you will make two relationships and you have to be careful about your field naming here. You will have one relationship where one document has many document terms and then again you will make two relationships and you have to be careful about your field naming here.

You will have one relationship where one document has many document terms and you will rename the field for related document to be called Related Master Document and look up the Document Name and call it Primary Document Name. 

Then you will make another relationship but in this case you will call the field Related Supporting Document  and the lookup field will be called supporting Document Name.

I'm not really trying to sell my services here but if you're new to Quickbase and you have a small budget, it may be quite worth your while to scrape up enough consulting funds to support about 3 hours of consulting time.

The set up I'm describing will work wonderfully for your purposes but the show stopper will be it will be a little bit painful to enter these connection records. There is a much faster way to do that using native Quickbase but it's a bit too complicated to describe here.  

If you want to discuss this one on one, feel free to contact me at mark.shnier@gmail,.com or via QuickbaseCoach.com