Many-to-many subform with data input... How?

[para]

I've been dabbling with OpenOffice Base for a week or so but have not been able to achieve what I want: a Many-to-many subform with data input.

My tables represent a Person (with auto gen id), a location (with auto gen id) and a relationship table containing a person id, a location id and a string comment.

So far, I have been able to create the main form and the sub form and have got the sub form to display data from the relationship (entered by hand). i.e. display the person's details and the locations with which they are associated.

What I have not been able to do is to add or delete locations to the subform list.

Can anyone help me with this? Ideas?

Thanks

Paul

[Villeroy]

Have a look at this database by DrewJensen http://user.services.openoffice.org/en/ ... php?id=649 relating to http://user.services.openoffice.org/en/ ... =61&t=3566

[para]

That's it!

I was pretty close. Still not sure what I was doing wrong but it works now.

Thanks for the tip!

Paul