D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] hk-classes and knoda

 

On Wednesday 04 July 2007 16:53, Neil Winchurst wrote:
> Are there any experts out there on knoda and hk-classes?
>
> I am using knoda as a front-end to mysql. I am still learning about it.
> (I have worked with databases for many years so I mean that I am
> learning about knoda and hk-classes).
>
> I am testing a setup with a form using two linked tables. The tables
> are 'sales' and 'products' I have set up the relationship all right as
> far as I can see. For each field on the form I have to select from two
> datasources. This was the first surprise. I expected to have just one
> datasource available showing all the columns from both tables. The
> choice is between
>
> A. sales
> B. products [sales]
>
> Using A I get only the columns in sales.
> Using B I get only the columns in products.
>
> Second surprise. I would have expected to have all the columns from both
> tables available to me from at least one of the datasources, which is
> how it worked when I was using  Paradox. I can't seem to find any way
> round this.
>
> Any pointers or suggestions from anyone please?
>
> Neil Winchurst


-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html