Question data and responsive group

Hi, I’m trying to build an inventory tracker app (management)

This is my data

Customer
Name - Text
Email - Text

Order
Number - Text
Customer - Customer
Date - Date

Material
Name - Text
Quantity - Number
Unit cost - Number

Summary
Customer - Customer
Order - Order

I have 4 pages

Page 1. Customer for adding and editing a customer

Page 2. Order for adding and editing an order (with a drop-down menu to choose a client)

Page 3. Material for adding and editing a material

Page 4. Summary

My question is why I am not able to display a repeating group on my summary page with my data

Order number
Order date
Customer name
Materiel name
Materiel quantity
Material Unit cost

Thanks for your support in advance :slight_smile:

Cheers Alex

@alexjalbert.combined

I didn’t quite understand why you need the “summary” table, mind to explain why?

One solution we have for this is changing the Database to

Customer
Name - Text
Email - Text

Order
Number - Text
Customer - Customer
Date - Date

Material
Customer - Customer (new field)
Order - Order (new field)
Name - Text
Quantity - Number
Unit cost - Number

Summary [can delete]
Customer - Customer
Order - Order

On Page 4, what you can do is include the repeating group and:

  • do a search for materials, where customer = current customer
  • from there you have all the fields you need.

Optional:
Include the field “List of materials” in the Order table. This might help if you need to list the materials for a specific order on some screen, but remember to keep this list and the table Materials in sync.

Does it makes sense to you?

Great thank you