Access field on a form to view previous records for thecurrent applicant

[dccooke]

I have a database of customer applications. Each record is tracked by the applicants ID and the application date. Every time a customer applies, a new record is created.

I would like to provide the employee reviewing the application a field where they can view data (Disposition and date) from the applicants previous applications, if any, as they work the current application.

in my head this would be easiest in a text field at the bottom of my form to display the application date, completion date, and disposition of the application.

any help would be greatly appreciated

[PhilOfWalton]

With respect, not the way to do it.

You need a table of Customers containing only information pertinant to customers - name, address, phone, email, sex, age etc with an Automumber Key - let's call it CustID

Then a second table for Applications containing ApplicationID as an AutoNumber Primary Key, CustID as a foreign key and then the information on application details - dates, disposition etc.

Then set up end enforce referential integrity between the 2 tables using the CustID as the link.

Create a form based on the customer.
Crete a continuous subform based in the applications and place this on the main form. Set the LinlkMsterFields & LinkChildFields to CustID.

That way you have a clear record for each customer and can add new applications for that customer to the Subform.

HTH

Phil