erich.wanker Posted May 10, 2016 Posted May 10, 2016 Hello, i have 2 tables: 1st tabel is named "S_TERMIN" and has "TERMINNAME" String (the name of the schedule) "ID" Integer (primary Key not null) 2nd Table is named "S_TERMIN_WAS" and has "LINK_INR" Integer -< is linked to the S_TERMIN.INR "BESCHREIBUNG" String (the work-order) One Schedule can have a lot of Work orders ( one record of S_TERMIN.inr is connected to a lot of S_TERMIN_WAS.link_inr records..) Now i want to display the scheduls and the belonging work-infos of each schedule in a unidbgrid how can i do this? ThanX for help Erich Quote
bugra Posted May 10, 2016 Posted May 10, 2016 Hi; I think join two table with SQL will help you. Quote
zilav Posted May 10, 2016 Posted May 10, 2016 Yep join them and group in UniDBGrid by TERMINNAME field. Or just go with traditional Master-Detail in separate grids. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.