skwilliams
03-07-2002, 08:44 AM
I have a table1 and a form1 which refers to it. I also have a table2and a form2 which refers to it.
I need to be able to input data into form1 and store it, such as:
Name SSNo Phone
Jane Doe 123-45-6789 812-555-5555
John Smith 987-65-4321 800-555-5555
In table2 I need to be able to select "John Smith" for example from it's name field as a drop down list and have the SSNo field autofilled with 987-65-4321 and Phone autofilled with 800-555-5555
I don't want the name field to be a dropdown list in table1 because I'll need to input that information.
I need both tables because the same information will be used in table2 each month along with additional information not in table1, so it would be easier to just choose a name from a dropdown list than enter the name, SSNo, and phone. And this gives my users the ability to add information to table1 via form1.
I'm using Access 2000.
Thanks.
I need to be able to input data into form1 and store it, such as:
Name SSNo Phone
Jane Doe 123-45-6789 812-555-5555
John Smith 987-65-4321 800-555-5555
In table2 I need to be able to select "John Smith" for example from it's name field as a drop down list and have the SSNo field autofilled with 987-65-4321 and Phone autofilled with 800-555-5555
I don't want the name field to be a dropdown list in table1 because I'll need to input that information.
I need both tables because the same information will be used in table2 each month along with additional information not in table1, so it would be easier to just choose a name from a dropdown list than enter the name, SSNo, and phone. And this gives my users the ability to add information to table1 via form1.
I'm using Access 2000.
Thanks.