Forms for related tables

[davidmc]

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

[RPG]

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

[dacm]