Quote Originally Posted by orange
What is the purpose of the ID field? How is it assigned?
What is the database/project you are working on?
The purpose of the ID field is to query several tables that I have linked. I don't understand your question of how is it assigned. It is already in the table. I just want the user to be able to enter more than one ID when prompted by my criteria in my query.

The database/project is a report generator for something confidential. I need to generate a report that pulls from several tables/queries and this is one aspect of it. Previous aspects of the project were met/done by entering one value. This part requires my user to be able to enter a variable number of values(ID's). I am unclear how to do this.

Any help is greatly appreciated. Thank you.