I am trying replicate a database I have in Access with InfoPath and SharePoint lists.
Currently I have two lists which are related to each other. List one is Suppliers (Parent) and list two is Factories (Child). The relationship between suppliers and factories is one to many, so each supplier can have a list of different factory locations.
I have created a new content type for suppliers from Infopath, however I'm struggling to get the form to display as I would like.
The way I want it structured is when a new Supplier is created and all the relevant information is being filled in at supplier level on the form there is an option to add a factory to that supplier which will bring up a new form to fill in the factory information, allow the user to submit it and go back to the supplier form. The supplier form would then have a table with a summary of the factory (or factories), the user can then have the option of clicking into the factory to view/edit further information or add another factory.
Basically the same functionality you would have within Access with a sub-form.
Is this possible and if so does anybody have some rough guidelines on how to go about it?