Building a lease-tracking db
Posted on 2008-11-16
I own a lot of equipment that I lend/rent out to friends/business partners. Until now, I have not felt a need to develop some way of tracking the equipments location, but it has become necessary. Therefore I am building a database in Access to accommodate this.
ID,Equipment, Price/day, Price/week,Condition,notes,purchase price, purchase date, returned
tbl_contacts (linked to my separate contacts db)
ID, normal address book info
ID, Equipment (lookup tbl_owned.ID), Contact (lookup tbl_contacts.id),Date Taken, Condition Taken, Date Returned, Condition Returned
When you add a new entry to tbl_leases, via frm_leases, and provide a Date Taken value, tbl_owned.returned should become 0 (no). Then when you update that entry with a Date Returned value, tbl_owned.returned should become 1.
I don't know how to do this. I tried to write a vb code:
date_returned after update
tbl_owned.returned = 1
but that returned the "Object required error." My guess is I am referring to the table or field in the wrong way, but I can't seem to get a handle on such references. Thanks.