Re: cascading link between tables

Hello!

I understood that this can be done by defining a Query.
And you can use this query by adding a Query link in
your MasterBlock of your Form.

This was that easy.

Best wishes to rekall users.

----- Original Message -----
From: "Mehmet Seckiner" <seckiner-jjFNsPSvq+iXDw4h08c5KA@xxxxxxxxxxxxxxxx>
To: rekall-TvUNdCdnGOiN0BpGcQGnph2eb7JE58TQ@xxxxxxxxxxxxxxxx
Subject: [Rekall] cascading link between tables
Date: Sat, 18 Jun 2005 20:28:38 +0800

> 
> Hi again!
> 
> In my scenario, there are staff in our company that are
> responsible of some operations. For example in sales department
> there are three SALESPERSON s. And these are some of the
> samples from all the personnel table. Maybe 200 total personnel
> working for that company.
> 
> After each operation -for example a sales operation-
> the operator have to specify which personnel is responsible
> for that operation.
> 
> To handle this scenario I designed three tables.
> 
> One is Staff (all the 200 personnel is recorded in)
> Other is Salespeople (Only the tree of them is recorded in)
> And the Sales table (It has a field like -ResponsibleCode-
> that I enter the code of the personnel there)
> 
> But in practice if I link Sales directly to the staff
> then in a link object there are 200 names listed and
> it is nearly impossible to select the correct personnel, and
> maybe an irrelevant personnel is selected by mistake.
> 
> And if I connect it to the Salespeople, only the Code of the
> staff personnel is recorded there because of Data Integrity Rules.
> And by a classic link in Rekall it is impossible to link three
> fields together.
> 
> I think there has to be an extra SQL object and an operation
> and maybe I will have to make a link with that SQL object.
> But I don't know how to handle that kind of a problem.
> 
> Thanks for all your help.
> 
> --
> _______________________________________________
> Check out the latest SMS services @ http://www.linuxmail.org
> This allows you to send and receive SMS through your mailbox.
> _______________________________________________
> Rekall mailing list
> Rekall-TvUNdCdnGOiN0BpGcQGnph2eb7JE58TQ@xxxxxxxxxxxxxxxx
> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall


-- 
_______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org
This allows you to send and receive SMS through your mailbox.

Powered by Outblaze