Using SQLite, possible to populate a listview in a fragment activity based on the column value of the selected list item in the previous activity?

This is a construction material list making application.

In the main activity a listview populates with names of all current construction projects. Each project has a rowid in the projects table.

There is also a lists table. Each list will belong to a project and there can be several lists for one project. Each list (row) in the lists table will have a project rowid corresponding to the project it belongs to.

The goal is to be able to select a project from the main activity, start the fragment activity, and populate only the lists belonging to the project selected. Is this possible? How can this be done? Someone please help me.

I am not showing code because I feel like it's pretty basic.