Subforms and autofill

[fredlef]

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

[Zizi64]

I must be doing something wrong.

Yes, for example you posted your question into the place of the tutorial descriptions.

[fredlef]

Apologies - if someone can delete it that is fine.

[Villeroy]

[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.

[fredlef]

Thanks that helps.

Fred

[Villeroy]

and this takes us further to "power filtering":
http://forum.openoffice.org/en/forum/do ... p?id=14591

[fredlef]

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