i'm trying to teach myself access to build an asset register for the office - the templates i have found to download all look like they need a massive amount of editing to be how i want them. i have a 1000(!) page reference book on it and it is serving me well but theres one thing i want to do that i can't find in the book, so i'm wondering if its possible or not:
in my database, among other tables that have no relevance, i have an equipment table and an asset number table. there is a field in the equipment table that links to the asset number table - i created the link by using the 'lookup wizard'. this is fine and works well, but i also have a field for entering associations, for example my PC is asset number 0001 and the monitor (an 'associate' of the PC) is asset number 0002 - for the associations field i have used the lookup wizard again that looks up the asset number.
on the equipment form i have fields for serial numbers etc. what i want is a button next to the associations on the equipment form, so if i'm on the record of asset number 0001, when its clicked it autmatically takes me to the asset number 0002 record
is this possible? if so, how can it be done?
thanks in advance for suggestions