Hello,

 

I'm working on a solution whereby Tools (records added on a Tools form) should be able to be checked out, or assigned, to a Project record, created on another form.  A Project can use many Tools, but a Tool may only be assigned to one Project at a time.  I would like the Project layout to have a portal showing any and all assigned tools, and the Tools layout to have a field indicating to which project it is assigned.  I'm pretty much a novice and I'm having trouble hashing out the relationships, fields, and layout here.  Any ideas or help?

Basically the answer depends on whether you want to keep a history of these assignments or not.

History of the assignments isn't really necessary; just where things are currently for organization and validation purposes is enough.

Well, then this could be very simple. Of course, there's room to make the user interface a bit fancier - but the data structure is just that.

Borrow.fp7.zip