I am trying to create some Infopath forms in Sharepoint to update some SQL Server tables, e.g tblInterview and dimDate
There is a dateID field in tblInterview that is a foreign key to the dimDate field dateID.
I want to allow the user to select the date via a Date Picker field, but save the dateID value in the tblInterview table.
If i set up an association in the external content type will this allow me to achieve this?
If you have any links to good sites that discuss using info path to create applications in Sharepoint, then I would love to see them too. :-)
Thanks in advance.