I'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!) I see that the primary table that one specifies must have the primary key for any relationship it has with other tables. However, in my design the table ("Actions" table) I want users to fill with data is a composite of foreign key i.e. each "Actions" record is made up of a foreign key to the "Users" table, a foreign key to the "Action_types" table, a date/time filed and a result field. So really I want the "Actions" table to be the primary and have relations to Users and Action_types. Any suggestions? Thanks in advance!