Hi - I'm trying to create an 'orders' database. The idea is that you would have an Order Form and you could enter a person's last name (for example) and have it auto-populate address fields from the address table. I thought a sub form would do that but that does not appear to work. Do I need to use a query of some kind to do what I want to do? Any guidance appreciate.
Hmm - also when I search on the sub form it doesn't find any record. I must be doing something wrong.
Thanks,
Fred
Subforms and autofill
Subforms and autofill
Openoffice - 4.1.7
MAC 10.15.3
MAC 10.15.3
Re: Subforms and autofill
Yes, for example you posted your question into the place of the tutorial descriptions.I must be doing something wrong.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Subforms and autofill
Apologies - if someone can delete it that is fine.
Openoffice - 4.1.7
MAC 10.15.3
MAC 10.15.3
Re: Subforms and autofill
[Example] Relations reflected by list boxes in forms
A list boxes references another table's primary key to fill up a foreign key of the current form.
A subform references another table's related row set having the same foreign key as the selected parent form's primary key. When inserting a new record into the subform, it inherits the linked key(s) from the parent form.
A list boxes references another table's primary key to fill up a foreign key of the current form.
A subform references another table's related row set having the same foreign key as the selected parent form's primary key. When inserting a new record into the subform, it inherits the linked key(s) from the parent form.
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
Re: Subforms and autofill
and this takes us further to "power filtering":
http://forum.openoffice.org/en/forum/do ... p?id=14591
http://forum.openoffice.org/en/forum/do ... p?id=14591
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
Re: Subforms and autofill
Thanks! I appreciate the assist.
<edit> - I've looked over the db. I'll have to dig into it but it looks really really helpful.
Thanks again.
Fred
<edit> - I've looked over the db. I'll have to dig into it but it looks really really helpful.
Thanks again.
Fred
Openoffice - 4.1.7
MAC 10.15.3
MAC 10.15.3