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 
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?
