I have 2 grids the 1st one lists date and race meetings in uk horse races.
(Table1)
The 2nd grid lists the time and race meeting. (Table2)

See attached picture...2grids.png

I want to click on grid1 row selecting a meeting to populate grid2 with I
dont want
to join the Tables because I want grid1 to stay static and then from grid2
be
able to select a row to populate a 3rd grid with all the runners in the race
selected.

Rita

"Rita" <nospam@nospam.com> wrote in message
news:842DBEA5-5D00-451F-86C2-497085691A2D@news.elevatesoft.com...
>I have 2 grids the 1st one lists date and race meetings in uk horse races.
>(Table1)
> The 2nd grid lists the time and race meeting. (Table2)
>
> See attached picture...2grids.png
>
> I want to click on grid1 row selecting a meeting to populate grid2 with I
> dont want
> to join the Tables because I want grid1 to stay static and then from grid2
> be
> able to select a row to populate a 3rd grid with all the runners in the
> race selected.
>

You can usually manipulate what is presented on Grid2 by changing the filter
on dataset2 onClick of grid1.

Robert

Rita


Any reason why a standard master - detail relationship won't work?

Roy Lambert

Thanks Robert filters to slowwwwwww
Rita

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message
news:628DF609-974F-4530-B40F-A93EB605BC53@news.elevatesoft.com...
>
> "Rita" <nospam@nospam.com> wrote in message
> news:842DBEA5-5D00-451F-86C2-497085691A2D@news.elevatesoft.com...
>>I have 2 grids the 1st one lists date and race meetings in uk horse races.
>>(Table1)
>> The 2nd grid lists the time and race meeting. (Table2)
>>
>> See attached picture...2grids.png
>>
>> I want to click on grid1 row selecting a meeting to populate grid2 with I
>> dont want
>> to join the Tables because I want grid1 to stay static and then from
>> grid2 be
>> able to select a row to populate a 3rd grid with all the runners in the
>> race selected.
>>
>
> You can usually manipulate what is presented on Grid2 by changing the
> filter on dataset2 onClick of grid1.
>
> Robert
>
>
>

It all works fine like that  Roy but the reason is bandwith.
I read an article about master and detail tables being
dragged across the www pushing up your bandwith.
The guy gave an example by selecting country from the
main menu to  populate his table1 with stuff regarding
that country it was done without joins or master detail
and it lowered his bandwith charges. So here I'am a
couple of months on wishing I had bookmarked that page.

Rita.

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:DC38A1E4-4AB9-4BE4-9E03-93DA5C13D6F3@news.elevatesoft.com...
> Rita
>
>
> Any reason why a standard master - detail relationship won't work?
>
> Roy Lambert
>

Rita,

> It all works fine like that  Roy but the reason is bandwith.
> I read an article about master and detail tables being
> dragged across the www pushing up your bandwith.

MD links burn bandwidth by resyncing the detail table over the wire as
the master table is navigated. Activating cached updates should
eliminate that.

Eryk

Thanks Eryk that could be the way to go then.
How are you? are you back in Stoke or still in
Belamathingy ?

Rita

"Eryk Bottomley" <no@way.com> wrote in message
news:1BBA18F4-F817-4426-AEA7-3D5B25543B6F@news.elevatesoft.com...
> Rita,
>
>> It all works fine like that  Roy but the reason is bandwith.
>> I read an article about master and detail tables being
>> dragged across the www pushing up your bandwith.
>
> MD links burn bandwidth by resyncing the detail table over the wire as the
> master table is navigated. Activating cached updates should eliminate
> that.
>
> Eryk

Rita,

> How are you? are you back in Stoke or still in
> Belamathingy ?

Belarus ...Minsk, specifically. I still live there but I'm in London at
the moment on business.

Eryk

Rita


If the tables aren't to big what about streaming them across to in-memory tables then you only have to worry about bandwidth for the initial transfer.

Roy Lambert

That is oneway I suppose but the plan is
Server in Maidenhead
Table1 contains race tracks and venues for 2008 from
GB
Ire
Aus
RSA
Fra
USA
The data from them countries is appended to the country table
selected via the client menu. Thats not so memory hungry on
the server. If you ever used the Betfair site they use a website
for their bets and I guess its at their hq and they offer every type
of sport. My program wants to do it like the poker sites,
the client runs the app the data only comes over the www = lower
bandwith plus only horse racing.
The only time the bandwith would shootup is Sat/Sun or holidays,
take a bank holiday weekend 12 meetings in GB 20 in USA all
that data getting dragged by tens of thousands Betfair customers.
I dont have any idea how many customers mysite would attract
its only in the idea stage for now from a bookie friend.
The plan at the mo is to get a GB only version working with a
million quids worth of credit play money and release it on racing
forums. If it pans out and Dbisam can hold up then I will get a
highbrow DelphiDbisam guru to polish it off maybe as a partner.

Rita dribbling on again and again. ;-(


"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:270A9492-4304-4B1B-A77B-11F276DED1C6@news.elevatesoft.com...
> Rita
>
>
> If the tables aren't to big what about streaming them across to in-memory
> tables then you only have to worry about bandwidth for the initial
> transfer.
>
> Roy Lambert
>