OptimusPrime Posted January 14, 2011 Share Posted January 14, 2011 Dear All, I'm trying to track changes in a particular part of a database. Table: TableBooks Fields: - BookID - BookStatus (In/Out only) - BookName I need to create a table which records when each book is taken out and returned. I had some success in creating a table BookStatus: - BookStatusID - BookID - BookChange (timestamp, new on creation) I've linked the tables: BookID -- BookStatusID I've created a little script, which is triggered on BookStatus change: Go to Layout ["BookStatus"] New Record/Request This creates a new record, and the requisite timestamp. However I need to also import from the Book table the BookID (and eventually some other fields which are non-permanent and need to be recorded at the time), because otherwise I will know when a book was taken out or returned, but not WHICH book - and that would defeat the exercise. Thanks! OP Link to comment Share on other sites More sharing options...
comment Posted January 14, 2011 Share Posted January 14, 2011 I've linked the tables: BookID -- BookStatusID I think it should be BookID = BookID. If you allow the relationship to create records on the BookStatus side, you can enter new data directly into a portal to BookStatus placed on a layout of Books. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4822 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now