Hi Everyone.
I have an ongoing issue where related records are not found by the users. To stop this, I'd like to try and display related records in a datasheet view sub form on our main form.
So, I have the following table:
Lets say we have one item in for two methods, the item may have two serial numbers FX12345 and UT12345 with methods of Radiography and ultrasonics respectively.
The only thing that links the records up is the serial number excluding the first two characters.
in the query, I'm trying to use an * an the right function to limit the criteria for serial number from the table, so that I can then grab the serial number from the form and display only the related records by having a <> on the PKFLD.
How on earth do I get a like *(Right(Forms]![DayBook][SerialNumber],5)) to work as a critera?
Thanks for any help, and please ask if you require any other info.
I have an ongoing issue where related records are not found by the users. To stop this, I'd like to try and display related records in a datasheet view sub form on our main form.
So, I have the following table:
- MainTable
- PKfield (unique autonumber)
- JobNumber (auto generated unique identifier in format yy/xxxxx)
- Method (combo limit to list)
- SerialNumber
- Customer (combo limit to list)
Lets say we have one item in for two methods, the item may have two serial numbers FX12345 and UT12345 with methods of Radiography and ultrasonics respectively.
The only thing that links the records up is the serial number excluding the first two characters.
in the query, I'm trying to use an * an the right function to limit the criteria for serial number from the table, so that I can then grab the serial number from the form and display only the related records by having a <> on the PKFLD.
How on earth do I get a like *(Right(Forms]![DayBook][SerialNumber],5)) to work as a critera?
Thanks for any help, and please ask if you require any other info.