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

Newbie Help

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
jonathan.hinchliffe
Newbie
Newbie


Joined: 28 Sep 2010
Posts: 1
Location: North West

PostPosted: Tue Sep 28, 2010 4:12 am    Post subject: Newbie Help Reply with quote

Hi All,

I am new to Ooo & am designing a Base db, I have my tables all created & have the forms also but I am stuck with one problem:

I have two forms/tables (customers & quotes), they are related by customerID what I can't work out is this.....

When I enter the customer ID into the Quotes form I want the relevant address fields to be populated with the customer address data held in the customer table - does that make sense?

I am basically wanting to avoid double entry of related data.

T.i.a.

Jonathan
Back to top
View user's profile Send private message AIM Address
Silhouet
General User
General User


Joined: 02 Sep 2010
Posts: 10
Location: The Netherlands

PostPosted: Tue Sep 28, 2010 12:45 pm    Post subject: Reply with quote

Pretty new myself but it sounds like you need a customers subform.
Back to top
View user's profile Send private message
therabi
Super User
Super User


Joined: 01 Sep 2010
Posts: 562

PostPosted: Tue Sep 28, 2010 1:06 pm    Post subject: Re: Newbie Help Reply with quote

jonathan.hinchliffe wrote:
Hi All,

I am new to Ooo & am designing a Base db, I have my tables all created & have the forms also but I am stuck with one problem:

I have two forms/tables (customers & quotes), they are related by customerID what I can't work out is this.....

When I enter the customer ID into the Quotes form I want the relevant address fields to be populated with the customer address data held in the customer table - does that make sense?

I am basically wanting to avoid double entry of related data.

T.i.a.

Jonathan


Before you go more into it I would suggest downloading and reading "Mid level Base tutorial" at http://documentation.openoffice.org/servlets/ProjectDocumentList?folderID=778&expandFolder=778&folderID=778 . With out a good understanding of how a database works you will be fighting it all the time.
_________________
OOO v3.3.0 & LO v3.4beta on Ubuntu 10.10 and Win7
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
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