Jump to content
  • 0

Update 2nd column from combo box selection from second table


Hinsel
 Share

Question

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.

 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0
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:

image.png.3b9254c4951370b38e654215af625d00.png

 

Table 2:

image.png.bff40f7a49322fc1d8755f823ae5c56b.png

 

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

image.thumb.png.da7c9a5343b36c99b5965ecc404fbc66.png

 

Once ran, it should update accordingly

image.png.752a77da996a8e268ab7a0fcc2a89df9.png

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...