I am creating an application and trying to figure out how to do the following:
Problem 1:
Table 1: Is Inventory with following fields: InvID, Username, DateEntered, Manufacturer, Model, Serial Number, Location, Status :::: The status field has the following options: Available, Assigned, End of Life
Table 2: Is Tracking with the following fields: TrackID, InvID, DatedEntered, Serial Number, Assigned to, Supervisor, Ticket Number, Type of Allocation, Date Returned
Table 1 is master, and Table 2 is details and has a relationship so that when you look up a record in Master table it shows every entry from Tracking Table (IE: Everytime the Unit was assigned to a user and when it was returned)
What I am looking to do is create 2 views for Table 2 - One called Check Out and Check in. I have created a query that for the check out view it shows only records from the Inventory (Table 1) that have a status of Available
and 1 View that is Check In.
What I need help with is on the list page of of the Check Out View for the Serial Number to be a link that will open the record in Add Record (or button on called Check out) that once I enter the fields it will also update the inventory record to an Assigned Status and when the Check Out View After I enter the information that it change the inventory record back to Available Status.
Can this be done?