Dear Theanoula, Am Sonntag, 3. März 2013, 20:48:36 schrieb Theanoula: > <datasource name="dts_customer" connection="gnue" table="transactor" /> > > <datasource name="dts_cars" connection="gnue" table="cars" > master="dts_customer" masterlink="id" detaillink="customer_id" /> > > <datasource name="dts_contract" connection="gnue" table="contract" > master="dts_cars" masterlink="id" detaillink="car_id" /> > > > I have created the primary and foreign keys in the database. > When I search(in the form) in dts_customer.name I get all the info I need. > The same happens when I search in dts_cars.car_number(I get everything) but > when I search in dts_contract.contract_no I don't get the right info.
I haven't really worked with gnue-forms much lately (unfortunately), but IIRC, chained master-detail has some issues in forms. Having said that, I would suspect that actually this is not a pure linear chained master-detail: isn't the contract the thing that connects customers and cars? So actually dts_cars is a detail to dts_customer, but dts_contract would also be a detail to dts_customer? Thinking even more about it: can there be more than one contract per car? Or wouldn't contract and car be an 1:1 relationship, meaning that you could put both in the same table? Just thinking out loud... Thanks, Reinhard
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ gnue-dev mailing list [email protected] https://lists.gnu.org/mailman/listinfo/gnue-dev
