Hi all,
we have a logbook in access and we use that for entry. in one of the fields in the access form we have to enter our asset. eg:205. then i have to open excel sheet to get info for that asset which is circut ID number eg: 19/abcd/123456/ps
my question:
is there is a way/trick i can use in the access field, that when i type the asset no. it will link to excel sheet and locate that asset and list the Circut ID.
please help
thanks in advance
we have a logbook in access and we use that for entry. in one of the fields in the access form we have to enter our asset. eg:205. then i have to open excel sheet to get info for that asset which is circut ID number eg: 19/abcd/123456/ps
my question:
is there is a way/trick i can use in the access field, that when i type the asset no. it will link to excel sheet and locate that asset and list the Circut ID.
please help
thanks in advance