How can I populate a dropdown list for an external list's infopath form RRS feed

  • Question

  • I have a SQL table named jobs that has a columns id, name and status_id.  I have another SQL table called job_statuses with columns id and name.  I have these tables in BCS as ECTs.  jobs has an association with job_statuses.  I need the forms for the jobs External list to relate the status id to the job_status's id so that I can use at the status's name instead of id.  I found questions on here:


    this one I think says this is impossible, but the moderator seems to not know what associations are, so maybe there is hope.  But again in this question:


    the moderator says "cannot add an external data source to an external list form"  Before giving up I find this:


    this doesn't do a dropdown list but it does something similar.  Can someone please help me understand this stuff?  I'm not married to infopath, it just seemed like the better tool.

    Thanks in advance!


    J. Duke Rogers Communicore Technologies & Triangle Forensics
    Thursday, June 9, 2011 3:38 AM


All replies