Skip to main content

Associate record

  • June 8, 2022
  • 1 reply
  • 8 views

Forum|alt.badge.img+5

I community,

I need your help.

Actually i sell subscription plant.
The customer choose 3 or 6 month.
I create an automation on Airtable which duplicate the record (by month choose by the customer) and the automation associate product to delivery :

for example : order 201821222
The customer choose 3 month, the automation duplicate :
M1- 201821222
M2 - 201821222
M3 - 201821222
On these records, i have a column with the plants we have to send.

My needs : i want to display on interface the plant send on the previous month.
My employee could choose the plant depending on what has already been sent.
So, how can i associate these records and display the history ?

Thank’s for your help,

Matthieu

1 reply

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • June 8, 2022

Do you have only a single table, or do you have two linked tables: one for [customers] and another for [plant deliveries]? I recommend a two table system, and then you can use rollups to pass around info between the two tables.