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

Forms for related tables

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


Joined: 03 May 2012
Posts: 1

PostPosted: Thu May 03, 2012 1:35 am    Post subject: Forms for related tables Reply with quote

Hi,

I'm new to OOoBase, and need a bit of help with related tables.

I'm setting up a CRM-ish database for a healthcare practice, with the following (initial) tables:
    * Client
    * Appointment
I've got the one-to-many relationship already set up from Client to Appointment.
But I now want to reflect this in the forms. What I'm hoping to achieve within the Clients form is the ability to:
    * Have a button to create a new Appointment for that client. This button would need to open up an Appointment form with the ClientID column already set to the Client ID
    * Have another button to show all the client's appointments
Is there any way to accomplish this without having to write macros? I just want to get on with the job, I don't have the time to study APIs and write and debug code

Can someone please give me a few pointers, or at least some links to good resources that explain this stuff?

Thanks if you can help

Cheers
David
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Thu May 03, 2012 7:29 am    Post subject: Reply with quote

Hello

http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=42845

Maybe this example give you the information you need.

Romke
_________________
OOo 3.4.5 on openSUSE 12.1
Use this forum : http://user.services.openoffice.org/en/forum
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Fri May 04, 2012 10:23 am    Post subject: Re: Forms for related tables Reply with quote

davidmc wrote:
...a button to...open up an Appointment form with the ClientID column already set to the Client ID...without having to write macros...

Hi David,

If you really want this exact function, then you'll need to employ a macro.

Otherwise, use a SubForm as Romke suggested.
_________________
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