Reply to thread

Message: [QUOTE="Kristina Hangs via AccessMonster.com, post: 2559730"] Hi there, I am bordering on between basic and intermediate user of Access. This is my situation: I have been asked to create a database to hold information about people and their assessment details. I have created four tables. Counsellor, Client, Client Assessment, and Outcome. I have also created four different forms for each of the above information to be entered. However, when I enter information into the Client form, and then click on the "Client Assessment" button, I would like the Clients Unique reference number (primary key) to be copied over into the subsequent "Client Assessment" form. This is so people know which client they are entering assessment details for. I have tried the automated lookup option in the table design view area, which does not appear to work. How else can i copy over the details of ONE field that I have just entered in a form to a subsequent form? In other words, I have four different forms that will need to be linked as one record for a client (and the client's counsellor!). Please help! Krissy [/QUOTE]