Let’s say you have a database type of invoice
Lets say each invoice in your data would contain all the invoice data for a single invoice such as total, tax, etc
To fill out a repeating group you would
do a search for invoices
^^This will show all invoices in the database.
Inside do a search for you can restrict your search results
For example: If you wanted to look at new invoices in the last month you would use
created date > current date - 1 month
Now what would you do if you wanted to restrict invoices to the current user?
One way to do that would be to have a field in Invoice with type of User (not the name but the type of data of the field). Let’s call the field “the purchasing user” and give it type User
Then you would fill out your repeating group expression restrict a do a search for with this
the purchasing user = current user
Thats just one way to do it and a common one.
You can also add a field into the User type in the database that with the name “a list of invoices” and set the type to Invoice and make it a list of things.
Then your RG expression would be
current user's a list of invoices (with the RG type of Invoice)