| View previous topic :: View next topic |
| Author |
Message |
jonathan.hinchliffe
Newbie
Joined: 28 Sep 2010
Posts: 1
Location: North West
|
 Posted: Tue Sep 28, 2010 4:12 am Post subject: Newbie Help |
 |
|
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 |
|
 |
Silhouet
General User
Joined: 02 Sep 2010
Posts: 10
Location: The Netherlands
|
| Posted: Tue Sep 28, 2010 12:45 pm Post subject: |
|
|
| Pretty new myself but it sounds like you need a customers subform. |
|
| Back to top |
|
|
therabi
Super User
Joined: 01 Sep 2010
Posts: 562
|
| Posted: Tue Sep 28, 2010 1:06 pm Post subject: Re: Newbie Help |
|
|
| 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 |
|
|
|
