AnsweredAssumed Answered

Linking Tables by ID

Question asked by weedonpaul on Mar 12, 2013
Latest reply on Mar 12, 2013 by weedonpaul

Title

Linking Tables by ID

Post

     I have the starter solution time Billing. I want to alter it so that when I click customer it drops down a list of my current customers which are stored in a seperate table. I have made the mistake of using names before instead of unique numbers, so I want to avoid that.

     I have linked "Customers::Customer_ID" with "LineItemsByBillingID::K_ID_Customer" in the manage tables relationship I have created a value list using the companies from the customer table.

     My question is this: how do I get it so that I select a company and it copys the ID across instead? 

Outcomes