Datapage / View with multiple order lines for 1 customer

[RalfSSH]

Good morning,

 

I would like to create a "New booking" data entry form with 2 sections, the top section contains basic info (Table Booking_Summary), the lower section should be a table where I can enter multiple services for that customers booking. (Table Booking_Details)

Can anyone help me please?

I can combine both tables in View but that doesnt let me enter data for both tables at the same time.

Thanks a bunch

[KlisaN137]

Hi @RalfSSH,

You cannot edit both tables used in a View, you can select just one of the tables to be editable. If you just want to edit records from both tables, you may use approach from this Forum Post:

Otherwise, if you want to submit data to two different tables, I suggest you use Multipage Form, as described here, where each page will have another datasource:

https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-create-a-multi-page-form/

[RalfSSH]

Thanks a lot KlisaN137

That was exactly what I was looking for

[Queso]

Hi @RalfSSH, I found this thread useful! we have the same workflow trying to achieve.. Thanks @KlisaN137!!

Just to add.. I found this HowTo link very useful. You might check it as well: https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/