Hello,

My first post on this forum. Is it possible to access (check) the contents of a field in a related table using a script without leaving a layout? Have a three table relationship. Members, loans and items. The loan table joins the members and items table (many to many). I wish to check the loan status of an item before committing to an action from the loans layout. I would prefer not to this using a find method as it is cumbersome and time consuming. I have seen some references to [Relationship::tbl] but I am unsure what this feature offers and how to use it if it relates.

many thanks

I wish to check the loan status of an item

What exactly is "the loan status of an item" - how is it determined?

What exactly is "the loan status of an item" - how is it determined?

Loan status is Boolean. I currently have the loan status field within the items table.(MembersTbl << loansTbl >> ItemsTbl). I need to check whether the loan status has been closed before I issue a new loan for any item. The loan status is true when the loan is initiated and false when returned. I can not rely on the user input to close the loan off when the item is returned, so I need to check the loan status before it is loaned out again.

I could search through the loans table to see if the item is on loan but that table holds a lot of records. Secondly I would prefer not to leave the layout as it creates another step in the user's interface input experience. I am trying to keep the interface as simple as possible. Thanks for your interest.

I can not rely on the user input to close the loan off when the item is returned

But you can rely on the user to change the status in the Items table??

Anyway, once you select the item by populating the ItemID field in Loans, the item's status is given by the expression =

Items::Status

But you can rely on the user to change the status in the Items table??

Anyway, once you select the item by populating the ItemID field in Loans, the item's status is given by the expression =

Items::Status

Yes you are right. Just set the item as loaned as I have been doing and deal with the overdue aspect that will occur in the loans tbl in another way. Keep the two solutions separate. Thanks for your input..