Re: [libreoffice-users] Re: Base scenario

Hi Ian,
I'm not sure what you mean by automatic.Would you consider a list box with
a drop down list of all the member names with the equivalent member ID
being the input value  to the subform automatic enough? I've used this
approach many times on the project I'm working on.
In your form edit mode in the design view, click on the list box icon and
place a list box on your subform and follow the directions. Your source
table for the list box display will be your Member table and
the data to appear in the list box will be your "member name"  attribute of
that table. Finally, you will select the matching attributes from the two
tables which links them. The Member ID number In the e-mail table and the
Member ID from your member table (I'm guessing) will be the attributes
you'll link. In this way, when you click on a name in the list box, you'll
be inserting " member ID" into that form.
Hank
.

On Thu, Dec 27, 2012 at 4:09 AM, Ian Whitfield <whitfield@telkomsa.net>wrote:

> On 12/20/2012 04:18 PM, Alexander Thurgood wrote:
>
> > Le 20/12/12 14:46, Ian Whitfield a écrit :
> >
> >  Thanks for the feed-back Alex - appreciated!!
> > > OK - I have two Tables (Members and eMails). The "Main Form" brings up
> > > the Members Table with a button to pop-up a sub-Form with eMails that
> > > the Member has sent or I have sent to him/her. (This part I have working
> > > but at the moment it brings up ALL eMails!!)
> > >
> > > If your main form already contains the ID of the member, why don't you
> > > use the member ID as a filter criteria for your email form ?
> > >
> > > In form edit mode of your email subform, click on the form properties
> > > button, and then click on the three dots button to the right of the
> > > Filter field. This opens a filter dialog, where you can enter a Named
> > > Parameter for your filter, e.g.
> > >
> > > MemberID = :ID
> > >
> > > If you then save this Filter criteria, you will notice that the Filter
> > > field has been filled. You can then quit the Form Properties dialog and
> > > save your form.
> > >
> > > When you open your email subform, you will be asked to provide the ID of
> > > the member and the form will filter the results on the basis of that ID.
> > Thanks Alex
>
> (Hope you and everyone had a great Xmas and Best Wishes for 2013!!)
>
> Your reply to me has made me change my layout of my Forms. I have removed
> all fields from my Sub-Form except the two IDs, the date, Sent/Received
> box, Message title and the message itself. The Button on the main Form I
> have re-labeled as "eMails".
>
> So all I need now is for the Sub-Form to AUTOMATICALLY pick-up the Members
> ID from the main Form and to use as the filter criteria for which eMails to
> show. (I will also use this form to enter new eMails so the automatic
> pick-up of the Member's ID is also important here).
>
> I have tried a couple of syntaxes to do this with no luck - it always asks
> me for the Members ID!!
>
> Is there a way to automate this?
>
> I thought that I could use 'MembersID' (on eMail SubForm) =
> 'SchemaName.TableName.**FieldName' would work but so far no luck.
>
> Thanks for any advise.
>
> IanW
> Pretoria RSA
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org <users%2Bhelp@global.libreoffice.org>
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted