OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Trying to show information from one table in another

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Dr Fléau
Newbie
Newbie


Joined: 26 Feb 2012
Posts: 1

PostPosted: Sun Feb 26, 2012 9:20 pm    Post subject: Trying to show information from one table in another Reply with quote

Hi y'all, complete n00b here.

I managed to create 2 tables: the first ("Client") contains Client names, addresses, Equipment and Distributor information. The second ("Service") is a customer service tracker and contains Event, date and Note information.

I created a drop-down list in the "Service" form where I can pick a Client name from the "Client" table. That in itself is an accomplishment for me ! I would like to have a text box (or other appropriate box) be populated with information from the "Client" table when I choose a client in the "Service" form, namely, the Equipment list.

My goal is to track repairs and customer service calls. I need to know who has what equipment, what broke down, when, how often, and what got done. Any help will be greatly appreciated. Database management is new territory for me; every little step needs a lot of effort.

I'm on OOo 3.3.0, 32-bit Windows7, 4 Gig ram, 3Ghz, 3D mouse, 2 speakers, 1 monitor, 1 large cup of black coffee. Thanx to all.
_________________
On vient au monde froid, nu et affamé. Après, ça empire.
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Sun Feb 26, 2012 10:06 pm    Post subject: Re: Trying to show information from one table in another Reply with quote

Welcome Dr Fléau,

Dr Fléau wrote:
...drop-down list...pick a Client name from the "Client" table...I would like to have a text box (or other appropriate box) be populated with information from the "Client" table...


Grab "1 large cup of black coffee" and see:
Table relationship and forms
[Example #1] Filter/Search with Forms (leveraging SubForms)
How to access SubForm linking mechanisms
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group