Forms - subform problems

Hi,

I’m a newbie. I’ve experiences with MS Access, but now investigating if Airtable is better route.

Working on typical customers-order-shipping-inventory kind of application, I’ve come to following problem related to Form - subform:

  1. the customer may have several shipping addresses. Then in the Order form, after selecting which customer, I want to ask which address to ship to. In MS Access, I could easily associated the list with shipping addresses of the particular client, and user can select which one this Order for.
  2. want to create report of order list of specific client. In Access it will be report with form-subform. I’ve tried to use Filter in Airtable, but it’s static and everytime need to manually change the filter.

Please help to address those problems.
Many thanks in advance for your help.

Tengu