Complete multiple fields when selecting one variable from a Project / Library table?

I am wanting to know if it is possible to do the following:

There are occasions where we will be working across multiple Project Numbers which may have different clients - but all the holes are on the same "Site" (therefore I want to keep the data together)

I'd like to have a Project Table that contains the Project Numbers, Client for Project Number.

I would then at Point Level like have fields for the Project Number and Client (so this can feed through into the logs) BUT I would like the Client (or additional fields should I add them in) be populated based on the selection of the Project Number.