wenbow2003

Thank you for the quick response. As I am very new to this, I do have a couple of questions. Can there be more than 1 child table(I am assuming this is the same as a join table. If not, please correct me.) connected to do this? (I have attached a pdf picture of what my db looks like.) We would need to keep the history table, so we could track the prop's last bay(contact) in case it is not checked back in. Any help is greatly appreciated. Props_Lending_Library_example.pdf

I am very new to Filemaker and am attempting to create a lending library. I work for a small television production and am trying to manage the props that go out to the various set/bays. My problem is this: Some props have multiple numbers, and can therefore be divided and lent to more than one bay. THe main problem occurs when I check the prop back in. When I do this, it automatically selects the first prop checked out. This may not always be the first one back in. Is there a way to assign the history assets that are checked out a number, so that script can be written to coincide with that check out? I apologize if this has been covered before, but I couldn't find it anywhere. Thank you in advance for any help that is offered.