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

Question

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.

Phil Wade · Answer

Hi Paul

Make an ItemKey table (we will call it PROJECT_LIST). ItemKey being your project number, and add fields to this table for Client etc.

Add a field on your POINT table (we will call it ProjectID) that looks up PROJECT_LIST.

On reports use the <<Lookup()>> function to grab PROJECT_LIST fields based on POINT.ProjectID.

regards

Phil

Phil Wade
Datgel
Bentley Channel Partner and Developer Partner
E: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780

Get the most out of gINT with Datgel Tools.