https://www.infopathdev.com:443/forums/141.aspxQdabra is committed to answering InfoPath questions. However, we do not support Microsoft Access. For non-Access questions, please use the other boards.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/52684.aspxSun, 14 Mar 2010 16:46:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:52684TobyR0https://www.infopathdev.com:443/forums/thread/52684.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=52684<p>I&#39;ve just started using Infopath with Access and I seem to have come across a limitation (either with the design philospophy or more likely me!)&nbsp; I see that the primary table that one specifies must have the primary key for any relationship it has with other tables.&nbsp; However, in my design the table (&quot;Actions&quot; table) I want users to fill with data is a composite of foreign key i.e. each &quot;Actions&quot; record is made up of a foreign key to the &quot;Users&quot; table, a foreign key to the &quot;Action_types&quot; table, a date/time filed and a result field.&nbsp;&nbsp; So really I want the &quot;Actions&quot; table to be the primary and have relations to Users and Action_types.&nbsp;&nbsp; Any suggestions?&nbsp; Thanks in advance!<br /></p>