Using several forms to fill in one record on a table.

[pelicanbuyer]

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!!!

[orange]

I recommend you get your tables and relationships designed and tested before getting too deeply involved in Forms etc.

I am guessing I could have 2 separate tables for the details and link the 2

This suggests that your basic table design is more of a guess than a design.

Here is a tutorial that will help you identify your tables, their attributes and relationships.

You should be working from a set of business rules/facts/requirements.
Good luck.