Well we (and by that I mean ME) are no further along. I am using two MS
Access tables. Can I email you the rubbish I have produced so far - you
may laugh at your discretion!Regards,Bev.
Hi Paul - I was wondering if I could pick this up with you again - I
thought I could washmy grubby little hands of it all, but sadly no, I
have to try and resolve the issue and any help would be very gratefully
received.Regards,Bev.
I give up! I really can't see what I am doing wrong - I really can't. It
all looks like it should work but it blinking well doesn't - thanks for
trying to help anyway Paul.Regards,Bev.
Hi Paul - thanks again.Yes the query returns more than 1 result (in the
example I keep trying it sould return 3 records)The repeat subform for
each data item is also set.Do the settings in the ODBC properties need
anything specific - e.g. delayed cursor - and what about the BOF Action
and EOF Action settings (which I have to say I don't understand) - I am
very self taught in Livecycle and boy does it show!Regards,Bev.
Thanks Paul - I already have two data connections as there are two
different result sets I am working onTo clairfy - the first data
connection retrieves grant id, title name and address of all grantsThe
second data connection then retrieves financial data for all projects
related to those grantsThere are several records of financial data per
grant.So the first bit of code retireves all relevant data for the grant
selected.xfa.sourceSet.claimdata.#command.query.select = concat("SELECT
grt_title, ...
Hi there - I have followed Stefan Cameron's excellent blogs on linking
livecycle forms to data from an odbc connection however I have now
become stuck.Effectively I have a form that populates part of the form
with matching data for a specific id, however I then need to populate a
different part of the form from another database connection that holds
multiple records for that id.I have successfully completed the first
part (YEAY!) however the second bit I cannot do - I have tried using the
xfa.so...
Hi there - I have a date field called PjStartDate and I would like to
ensure that the date entered always formats to DD MON YYYYHow can I do
this as an exit event?The field is a date field and I have tried using
display and edit patterns but they don't seem to work. I know I am
probably doing something wrong - only just started learning
livecycle!All help appreciated.Regards,Bev.