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:
- 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.
- 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.