Subforms and autofill

Creating and using forms

Subforms and autofill

Postby fredlef » Sat Mar 07, 2020 11:20 pm

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
Openoffice - 4.1.7
MAC 10.15.3
fredlef
 
Posts: 4
Joined: Sat Mar 07, 2020 7:37 pm

Re: Subforms and autofill

Postby Zizi64 » Sat Mar 07, 2020 11:43 pm

I must be doing something wrong.


Yes, for example you posted your question into the place of the tutorial descriptions. ;)
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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.
User avatar
Zizi64
Volunteer
 
Posts: 9606
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Subforms and autofill

Postby fredlef » Sat Mar 07, 2020 11:52 pm

Apologies - if someone can delete it that is fine.
Openoffice - 4.1.7
MAC 10.15.3
fredlef
 
Posts: 4
Joined: Sat Mar 07, 2020 7:37 pm

Re: Subforms and autofill

Postby Villeroy » Sun Mar 08, 2020 7:24 pm

[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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28668
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Subforms and autofill

Postby fredlef » Sun Mar 08, 2020 8:25 pm

Thanks that helps.

Fred
Openoffice - 4.1.7
MAC 10.15.3
fredlef
 
Posts: 4
Joined: Sat Mar 07, 2020 7:37 pm

Re: Subforms and autofill

Postby Villeroy » Sun Mar 08, 2020 9:09 pm

and this takes us further to "power filtering":
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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28668
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Subforms and autofill

Postby fredlef » Sun Mar 08, 2020 10:12 pm

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
Openoffice - 4.1.7
MAC 10.15.3
fredlef
 
Posts: 4
Joined: Sat Mar 07, 2020 7:37 pm


Return to Forms

Who is online

Users browsing this forum: No registered users and 1 guest