[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [GNUe] foreign key question

From: Reinhard Mueller
Subject: Re: [GNUe] foreign key question
Date: Tue, 08 Jun 2004 22:38:20 +0200

Am Die, den 08.06.2004 schrieb address@hidden um 1:17:
> I'd like to offer a dropdown list to the user with a subset of the
> employees table records made with those ones that are indirectly linked
> to a known (constant condition) org record, with dept intermediate
> record (may be others conditions, but the one I've worried just now is
> this).

We had a quite similar problem in our hotline form and we were able to
solve it with appserver - with these indirect properties

> The org record definition has a 'nick' field, but org record isn't a
> 'user' record. What the user sees is a customer record, a provider
> record, or a shipping operator one.
> I'd like that, when the user is dealing with a customer record, the
> 'nick' (org) field has the focus and (s)he strokes up/down keys,
> navigates into customer records. I've solved the cuestion adding a
> type field to org records but I wonder if there is a way to do
> something like that without org table knowing about the class of record
> that is actually linking to one of its ones.

I'm sorry but I can't follow you here.

> El lun, jun 07, a las 22:22:24 Reinhard Mueller escribĂ­a:
> > Am Mon, den 07.06.2004 schrieb address@hidden um 21:27:
> > > I have an issue where a form record needs to hold the key of an employee
> > > belonging to a known org, but, as said before, employee records are linked
> > > to dept records, that are linked to org records. That is, there isn't an
> > > employee field that directly links to an org record. Is there a way for
> > > doing that kind of thing without re-structuring data?
> > 
> > Using appserver, you could access the org of an employee as a field
> > named "". You could filter by that, sort by that, or display it.
> > You could even display a field named "", if the org_org
> > table has a field "name".
> This sounds like what I am looking for. How could this be done? By mean of
> a 'virtual' or mediated datasource from gnue-form point of view?

No. By means of nothing. Just add a condition on the "" field of
the employee datasource. You can play as if the employee table really
had a field named "". Appserver will do all joins and everything
automagically. No extra action required.

> > However, I'm not sure if you are using appserver with this application.

> Not, I'm not still using appserver. It seems appserver is being heavily
> developed just now, and I have a lot of things to do with my app and a
> lot of them to learn about GNUe, out of appserver, so I'm trying to
> advance as much as I can do without appserver in both ways, the app
> and my knowledge.

That's ok :-)

Reinhard Mueller
GNU Enterprise project
No army can stop an idea whose time has come.
        -- Victor Hugo, 1802-1885

Attachment: signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil

reply via email to

[Prev in Thread] Current Thread [Next in Thread]