Update 2nd column from combo box selection from second table

[Hinsel]

I have two tables.  <Items>   &  <Sales> 

In the <Items> table:
Col 1: Item_Type  Col 2: Expiration_Days
Ex:  Col 1: Milk         Col 2: 20

In a separate table <Sales> I want to select and item from <Items> Col 1 (Milk)<a combo box> and have the value from <Items> Col 2: used to calculate the Expiration date in the future and enter the result into the <Sales> table in an adjoining cell in the same row. 

The result would look like this in the <Sales> table:
[Date]    [Item]             [ExpDate]
Today      Milk      Today + 20 days

Thanks for any assistance.

 

[TellMeWhy]

13 hours ago, Hinsel said:

I have two tables.  <Items>   &  <Sales> 

In the <Items> table:
Col 1: Item_Type  Col 2: Expiration_Days
Ex:  Col 1: Milk         Col 2: 20

In a separate table <Sales> I want to select and item from <Items> Col 1 (Milk)<a combo box> and have the value from <Items> Col 2: used to calculate the Expiration date in the future and enter the result into the <Sales> table in an adjoining cell in the same row. 

The result would look like this in the <Sales> table:
[Date]    [Item]             [ExpDate]
Today      Milk      Today + 20 days

Thanks for any assistance.

 

What do you mean by ComboBox? Is this List-String DataType? If so, you can't use that in Triggered Actions nor Application Task.

Here's an example, using Application Task. (Application Tasks are used when you already have data in your table, and you want to update another Table using the data there. Triggered Action is when you insert/change the records in the table, and then do some actions on another table based on what happened.)

Table 1:

 

Table 2:

 

Item_ID is important here so we know where to put the Expiration Date

 

Application Task:
You update the Table 2, and Inner Join the Table 1 using the Item_ID on both Tables

 

Once ran, it should update accordingly