How to get other info to come up in one field from input in another field

[Yellowbeard]

I am working on a data base where phone calls are tracked.
I have a table that lists building number, name, address in three columns.
I have another table with lookup fileds that list this other table with a pull down list.
Three pull downs with the number in one, the name in another, and the address in the last.

I would like to be able to put in the number or address or name and have the other fileds populated accordingly.
Now you have to select each one and you can select the wrong one in the different lookup, pull down list.

Also I have a date field that I would like to have the date come in automatically.
Any help would be greatly appreciated.
YB (martin)

 

[Mike Painter]

I am working on a data base where phone calls are tracked.
I have a table that lists building number, name, address in three columns.
I have another table with lookup fileds that list this other table with a
pull down list.
Three pull downs with the number in one, the name in another, and the
address in the last.

I would like to be able to put in the number or address or name and have the
other fileds populated accordingly.
Now you have to select each one and you can select the wrong one in the
different lookup, pull down list.

Also I have a date field that I would like to have the date come in
automatically.
Any help would be greatly appreciated.
YB (martin)

I would suggest you start by reading the help section on what a relational
database is and then looking at the Northwind database which has many
examples of what you want to do.

A search on "default" in help would show that placing Date() or Now() in the
default for the field will do what you want.

Contrary to popular opinion, professionals *do* read manuals and use help
files. (Nerds like doing it