P
primixr8
Hi
I have created a simpel service database with the appropriate tables:
Jobs, Clients, Orders and suppliers. I also created a query for the
jobs table, but now I wish to search based on a users prompt for the
Client name in the lookup field from the client table. I have tried
wild cards and they do not work, they only work for the fields that are
apart of the jobs table and don't work with a lookup field. Can anyone
help with the criteria, it would be much appreciated, thanks.
I have created a simpel service database with the appropriate tables:
Jobs, Clients, Orders and suppliers. I also created a query for the
jobs table, but now I wish to search based on a users prompt for the
Client name in the lookup field from the client table. I have tried
wild cards and they do not work, they only work for the fields that are
apart of the jobs table and don't work with a lookup field. Can anyone
help with the criteria, it would be much appreciated, thanks.