Displaying data from related tables

Creating and using forms

Displaying data from related tables

Postby storebased » Mon Jan 14, 2008 1:47 pm

Hi there,

I want to show data from a table that is related to the table which is the source for a form

Just as an example: Suppose I got a
Clienttable : (id, name, countrynr)
and a
Countrytable (countrynr, countryname)

I relate those to on common field "countrynr" (tools, options, relations)

Now I make a form based on Clienttable. I want to show (readonly) the field countrytable.countryname.

How can I display this data? Thanks in advance.
storebased
 
Posts: 1
Joined: Mon Jan 14, 2008 1:39 pm

Re: Displaying data from related tables

Postby kabing » Mon Jan 14, 2008 2:47 pm

You need a subform for the second table.

Take a look at this thread from the OpenOffice.org Forums.

If you still have questions after that, please post back.

If that solves your question, please at [Solved] to the title of your first post in this thread.

kabing
NeoOffice (app store version) OpenOffice.org 4.1 and LibreOffice 4.3 on Mac OS X El Capitan
OpenOffice.org 4.1.2 on Windows 10 (Previously on Vista)
User avatar
kabing
Volunteer
 
Posts: 678
Joined: Fri Nov 23, 2007 12:05 am
Location: Midwest, USA


Return to Forms

Who is online

Users browsing this forum: No registered users and 1 guest