Hi Community;
I'm a relatively new in programming overall... I hope one of your can assistance me to solve an issue related to macros in access.. so I got this query of an Assets leased, it is a relational query that involve an asset linked to an employee.
Here some details:
One employee can be have many assets leased.
One asset only can linked to an employee.
For that reason I got an main menu with Assign Asset, return asset for opening those forms.
In te assign asset I'm assigning asset to an employee, but I'd like to know how to prevent that an asset without a record of return:
The form of the return of asset only add the return date and put that record in "Inactive", and the form of assign request the ID of employee, asset, date of delivery and put the device in "Active".
I've attached some image of the macros that I'm using in button save and new for do that, and images of the project.
I hope anyone can give a way how to do this.
Thanks