ok ok i got the way but i still can't figure the Query to use. anyone plz?
dixieee
no query just set the fields you want to populate equal to the field from
your secndary datasource and then click the filter button and specify where
username in the secondary datasource = USERNAME DISPLAYED IN THE FORM FIELD.
Ie USERNAME field is populated on opening the form the field is called
EmailAddress its default value is displayed from a secondary data source
called UserDetailsSecondary column name EmailAddressSecondary.
It would have a filter on it saying Where UsernameSecondary is equal to
USERNAME.
Do this for all the other fields and it is all sorted. This is provided the
secondary data source contains the information you need. If not you need to
find it first.
I hope this helps
Cheers Adam
> ok ok i got the way but i still can't figure the Query to use. anyone plz?