B
Bandit
Can I create a form that will search a table for a specific record within the
table without changing the underlying table? The tables have inventory for
parts. I want to allow the mechanics to open a form and type in one of
several varaibles such as: A part name or part number that will give them
the location of their part. I do not want them to be able to change the
table. I created a form using the form wizard but when it asks me what table
has the related info and I tell it, it automatically brings up the first
record in the table. Also, if they put in a part name, it will only bring up
the first item in the table when if fact there may be several items with the
same name. I want all items of the same name to appear and then they can
choose which one they want. Any suggestions?
table without changing the underlying table? The tables have inventory for
parts. I want to allow the mechanics to open a form and type in one of
several varaibles such as: A part name or part number that will give them
the location of their part. I do not want them to be able to change the
table. I created a form using the form wizard but when it asks me what table
has the related info and I tell it, it automatically brings up the first
record in the table. Also, if they put in a part name, it will only bring up
the first item in the table when if fact there may be several items with the
same name. I want all items of the same name to appear and then they can
choose which one they want. Any suggestions?