Hello,
I have 2 tables: 1st with product, error_code, cost, etc fields; 2nd- error_code, date, scrap_qty, etc. 1st table are with data.
I would like to create form which enters data to 2nd table.
The problem is that I want to choose product and see all error_codes in form according product (from 1st table). When I want enter scrap_qty according error_code fields data.
For a moment I don't have any idea how to do it. Can someone help me solving it?
Form entering data according other tables data
Form entering data according other tables data
Last edited by RoryOF on Wed Sep 16, 2015 9:03 pm, edited 1 time in total.
Reason: Corrected typo in Subject [RoryOF, Moderator]
Reason: Corrected typo in Subject [RoryOF, Moderator]
OpenOffice 5.2 on Windows 7
Re: Form entering data according other tables data
If your database has its relations right, list boxes and subforms are the key.
[Example] Relations reflected by list boxes in forms
[Example] Relations reflected by list boxes in forms
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice