You can achieve your needs through the Dynamic List Filtering function.
Note: The Lookup column does not support the Dynamic List Filtering function
1.Create the Choice column named Materials in the ListA.
2.Create the Choice column named Material Name in the ListB.
3.Create a Site page and add List web part to insert ListA and ListB
The access request feature works together with the share command for sites. If someone who is not a site owner for a site (that is, someone who does not have full control for a site) uses the share command to invite other people to view a site, then that action will generate an access request for the site owner. A site owner can then approve or decline the ...
If you try to paste names of users in people or group, it will not get resolved as it is not considered a unique property.
You can try to paste the email address of users (I have used this earlier) or SharePoint User Id (generated in User Profiles)