Multi-record subforms

[SNScott]

In my explorations so far, I can only get multiple records to appear simultaneously in a subform if I use Data Sheet view. If I try to use Columnar or Block formats in the wizard, I can then only view one subform record at a time. I can't find anything in Design view which lets me change this. Have I understood correctly?

I have looked various places in the documentation for an answer. However, I'm new to Base, so if I've missed an existing answer to this question somewhere, please tell me.

[DrewJensen]

I believe I understand what you are asking about - and if so the answer is that there is no support for this with the OpenOffice.org data aware controls.

There is no good way to get that behavior - you could create multiple sub forms. Since each sub form is linked to a separate result set you could do something with LIMIT <count> <offset> modifiers to the sub form select statements - but that would not really be the same as a multi-record panel.

[williaba]

Hi Drew. I have two multi-record forms (A and B) with a Primary Key/Foreign Key relationship. I would like to select/highlight one of the records in form A and bring up the related record(s) in form B. I've looked at 'Push Buttons', but can't attach one to the end of each record in Form A. I've considered a single Push Button, which when pushed would run a 'select .. into' into form B, based on the highlighted (current) record in form A. But, in any case, how do you associate an SQL statement with a Push Button?

[DrewJensen]

Well you can have a sub-form or a sub-form as one way to do that. You simply have to add the second and subsequent sub-forms by hand.

I have an example of that at OOoForum, but think I will just move that over here - so check back a little later for the example.

[Colin@oxford]

I am also interested in this. MS Access calls it "Continuous forms".
I am trying to move my database from Access97 to OpenOffice but currently this is a real sticking point