Auto Fill

[dand028]

Can you please help me.

I have a master database created, it houses my donor contact history, each
donot has been assigned a donor number. i want to create a table, in this
table i want to be able to type in the donor number and the rest of the field
automatic populate bases upon the information from the master database.

is the duable in MS access 97?


Thanks

 

[John W. Vinson]

Can you please help me.

I have a master database created, it houses my donor contact history, each
donot has been assigned a donor number. i want to create a table, in this
table i want to be able to type in the donor number and the rest of the field
automatic populate bases upon the information from the master database.

is the duable in MS access 97?

Not as stated. Tables are designed for data storage, not as tools for data
searching or display.

Instead, create a *FORM* based on your table. Use the toolbox combo box wizard
to create a Combo Box displaying the donor number (or, better, the donor
number, name, and other identifying information); use the wizard option "Use
this combo to find a record".