Linking Tables by ID
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?