I would like to use several forms to help build one record in a table and I am just trying to get my head around the best way to do it. I am fairly new to access so go gentle with replies!
Form 1 with ask for details about one aspect of the client such as personal details.
I will then need a next button and it will go to form 2, summarising what has been inputted and now asking for the next lot of details such as their requirements.
I am guessing I could have 2 separate tables for the details and link the 2 but I have inputted lots of data already and I want to use that table as the source.
The main bit I am concerned about is when I go to form 2, how will it know to relate to the client I put in form 1?
I hope that makes some kind of sense but feel free to ask for clarification on any of it.
HELP!!!