Bringing it together...

[kiwiora]

The Scenario - Our firm has mobile phones and dictaphones which it would like to keep track of. e.g Joe Bloggs borrows mobile phone for 3 day trial. I need to register that the person has it, when it was returned, for what matter and keep it historically so that when the phone bill comes in i can charge the appropriate matter to the bill.

I have so far created a main screen which holds standard information (using the asset register fmp template) for the actual phones themselves. I then have a related database which has all the many makes and models of phones. Then i propose to create another database which is purely borrowing information

I'm thinking of something that works like this... main screen with the mobile phone number, serial, make, model etc... bottom screen shows who currently is in possession of the phone and when dates borrowed/returend.

What i am having trouble getting my head around is having it so that whilst 'borrowing' database holds a record for each time the phone is borrowed, the only thing to display in the main screen is the current borrowing status, be "in house" if not loaned out, or "currently lent to Joe Bloggs till 1/1/1000".

I attach my current workings so far.. i suspect i have just not given myself enough headspace to think it through and am relying on you guys to see the obvious!! Please be warned I have mucked around with it and haven't bothered with pretty buttons yet

Cheers

mobilephone.zip

[andygaunt]

OK, you have a relationship for the loan status.

What you need to do is link the current record AND the loan status.

This requires a calc in both fields.

In the main file will be (result of text)

Item & ":Current"

In your lending file will be (result of text)

Item & ReturnConfirm

Use these in your relationship and set your fields to display from this relationship.

So, if item 1234 Nokia 3310 mobile is signed out by Andy Gaunt, this will display in the main file, until this item is closed (or returned)

HTH