Hi Hillary,
I know how to create forms in Access, but I would like to have forms in InfoPath as I want others to fill in these forms. I do not want employees to have to go make changes in the database.
I chose the database template within InfoPath and connected to my data sources. However, I want to know the proper way to connect to my tables as I cannot add all tables in one connection because some have one-to-many relationships and it throws an error, so I added them separately.
In any case, I would just like to know how to have a query field to lookup a function name from the functions table and use this to create a new record (a new delegation in the delegation table with its own ID) when the user submits. Therefore, I would have the employee choose a function and entity to outsource to, and when the user submits this creates a new record in the delegations table, since all my tables are connected. Every time I try to do this I choose the function table and function name field to lookup the data but it says that I should choose a field where I should lookup the data and not where it is stored. How does this work generally, if I have connected tables? What fields do I choose? It seems I cannot just add list boxes or any new fields for that matter when I already connected to data sources?
Kind regards,
Jovan