I am trying to create a Master Detail page using Radzen Studio and every time, it creates the add/edit page but no Master Detail page. I have two tables Customer with Primary key cu_cust_id and BinStock with primary key ID and a field cu_cust_id. I have set up a foreign key in BinStock table, primary key table Customer cu_cust_id and foreign key BinStock cu_cust_id. Can you see what my issue is or do you have any resources on how to create master detail page using Radzen Studio?
Hi @keithnarsansky,
Please send us your database schema as SQL script along with instructions how to reproduce the problem at info@radzen.com
Thanks for your help. I cleaned up the database and master detail page works great!!!
Now that I got the master detail page working good, I want to add a new table that I created as another grid on the master detail page. I tried just re-running data wizard hoping to overwrite my master detail page with the new table, but the project failed with numerous errors.
How do I add a new table to an already created master detail page using Radzen Studio?
Thanks again for your help!!!
Make sure you've checked all tables while inferring your data source, not just the new tables.
Here is what happened. I added a new integer field to a table and forgot to populate it and ran the data wizard to create master detail page which failed. Once I realized that I populated the field and re-ran data wizard, but it kept creating a number of errors that I could not seem to fix. So I tried creating a new app with Radzen Studio and it built with no errors.
I don't know if this is a tweak you can make to Radzen Studio to prevent this situation, but I will try to remember to populate a new field before running data wizard, lol.