Newbie Questions

Re: Utilize Main data source to reflect multiple matching results from secondary data source

gdgonzal — Tue, 08 Dec 2009 21:51:48 GMT

Hello Jimmy,

Well it's actually both....the screen shot above reflects data from our Siebel CRM (left side) and on the other side is data from another SQL dbase (right side). Like I mentioned the Siebel CRM data is related to the SQL dbase in a one-to-many relationship. So from that perspective I am querying data from both of these data sources, the data from the Siebel CRM is within the main data source and what I would like to happen is when the "Crystal_ID" within that field equals or matches the "Siebel_Crystal_ID" within the SQL dbase econdary data source it displays those results within a repeating table. The user should then see the relationship between these two seperate data sources displayed, add comments (submit) to an Access 2003 dbase that is acting as my back-end. So I essentially have three things that I would like to occur:

1. Query Siebel CRM data (which I can do using a unique key)

2. When the Siebel CRM single record equal/matches records within the SQL dbase it displays those results within a repeating table (using the Crystal ID to establish the one-to-many relationship) This is what I need help with...I can get this to work by adding the SQL dbase data to the main table but then I get an error when I attempt to submit a record to Access 2003.

3. Allow this queried data to be submitted to Access 2003 after the user adds comments.

Thank you for your assistance. :)

Re: Utilize Main data source to reflect multiple matching results from secondary data source

Jimmy — Mon, 07 Dec 2009 08:41:46 GMT

Do you need to copy the data to your main data source and be able to submit and save it, or do you just want to be able to display the data on your form.

If it's the latter, then all you need is a repeating table with some filtering. If it's the former, then the matter is a bit trickier.

Utilize Main data source to reflect multiple matching results from secondary data source

gdgonzal — Wed, 18 Nov 2009 17:12:17 GMT

Hello,
I have a main data source that contains a Siebel CRM Crystal ID (one) that may also correspond to a secondary data source's Siebel CRM Crystal ID (many-in repeating tbl). So we're talking a one-to-many relationship. What I would like to happen is that when I query a record from the main data source the corresponding matching secondary data source's Siebel CRM Crystal ID (many) are reflected within a repeating tbl.

I actually got this to work by adding the Access 2003 query that comprises the aforementioned secondary data source initially to the main table (see attached-data has been sanitized). Yeah it worked great until I tried to submit a record an received an error. When I reviewed the Main Data connection in see the following:"Submit status: Not allowed - A table is being used multiple times".

So I figured I had to setup the Access 2003 query containing this data as a secordary data source instead of part of the Main data source. Only issue is I cannot seem to get this to work the way I want, thanks for your assistance.

p.s. I should mention that the secondary data source within the repeating tbl doesn't actually reflect the Siebel CRM Crystal ID within the repeating tbl in its displayed results, but it is part of that Access query...I'm just not showing it since the user can glean this information from the Main Data Source's displayed results.