I have two tables. One is Equipment. There are fields: Barcode, Name of Equipment, Where borrowed (Linked). Other is Lending Equipment. There are fields: Lender, Barcode, Created Date, Where borrowed. How do I use a barcode to identify a device? How ...

I have two tables: Devices and Tasks. How can I link field from Task table to Devices table? I want to link next “Action Date” for dedicated devise from Task table to Devices table. I have Pro license.