I am creating an equipment database.  So I have my equipment form that has the item, manufacturer, invoice number, etc.  I also have a form that has our purchases on it.  What I would like to be able to do is to be in the equipment view looking at an item and click on the invoice number to pull up that purchase.

So let's say I have an HP computer and I'm looking at that record in the equipment view.  I scroll over to the invoice and it's invoice number 123576.  If I click that invoice number in the record it will pop up the purchase record for invoice 123576 so I could see what else was ordered at that time, etc.

Is there some way to do this?  Not just to create a relationship between the equipment record and purchase record, but to be able to click and pull up the purchase record based on an equipment record?