Hi All
I was hoping someone may be able to help me with a better way of displaying a field from a table, than using two DLookups.
I have three tables: tblLocation – tblAssets – tblFaults
The form is based on the tblFaults table. One of the fields is AssetID ( key from tblAssets) which I am using to then look up the location of that item as listed in tblAssets, but of course it is returning the key field of tblLocation which is a number. I have then created a second DLookup against this key field to display the “friendly” name from the tblLocations table.
I’m sure there is a better way but I just haven’t learnt it yet and I was hoping someone may be able to suggest something.
Thanks in advance.
I was hoping someone may be able to help me with a better way of displaying a field from a table, than using two DLookups.
I have three tables: tblLocation – tblAssets – tblFaults
The form is based on the tblFaults table. One of the fields is AssetID ( key from tblAssets) which I am using to then look up the location of that item as listed in tblAssets, but of course it is returning the key field of tblLocation which is a number. I have then created a second DLookup against this key field to display the “friendly” name from the tblLocations table.
I’m sure there is a better way but I just haven’t learnt it yet and I was hoping someone may be able to suggest something.
Thanks in advance.
