HI,
I have set up a form to input information such as:
id
name
import date
serial
export
my problem is in there are many serials for example 1234,1235,1236 all inputed in the same box sometimes it is only 1 serial sometimes it could be 20 or more all under the same id(primary key) and i want to make a query that will prompt the user to input the serial for example 1234 and have it search and display the information
id
name
import date
serial
export
but with only that one serial
thanks for your help