Im doing one project with two to three forms like enquiry form, registration form, invoice form etc. I use access as back end. when one user first fill in enquiry form, the details are stored in access table. then later the same user comes and fill in registration form. In registration form when the user enter the enquiry number then automatically the details of that particular user should be retrieved from enquiry table and displayed in registration page. I need help how to retrieve when enquiry no. is entered. please anybody help me soon. I have used the enquiry number as primary key in enquiry table and as foreign key in registration table.
Thanks in advance..