Table Lookup & fill in Access 2002

[Frank Reiss]

I am A Paradox user teaching myself Access. How do I
create a Look & Fill Lookup in Access. I want type in a
value (ie part number) in a child table and have all
related data from the parent table fill in all related
fields in the child table based on the value(part number)
entered WITHOUT using a query. Paradox has a very simple
Look and Fill function that does this. Does Access?

 

[Rolls]

Holy busted paradigm!

Using Access, fields contained in one table should not be used to "fill in"
fields in another table. Instead, link multiple tables as needed and
display the result via a form.

 

[John Vinson]

I am A Paradox user teaching myself Access. How do I
create a Look & Fill Lookup in Access. I want type in a
value (ie part number) in a child table and have all
related data from the parent table fill in all related
fields in the child table based on the value(part number)
entered WITHOUT using a query. Paradox has a very simple
Look and Fill function that does this. Does Access?

Access is more fully "relational" than Paradox, in my experience.

In Access, you would avoid as much as possible storing data
redundantly; i.e. you would keep part number in the Parts table AND
NOPLACE ELSE.

If you want to see parts information in connection with information in
a child table, you would create a Query based on the two tables. The
Query can include fields from both tables, and can be used as the
recordsource of a Form or Report, can be exported, can be searched or
sorted by any field in either table, and can often even be updated.
The Query fulfills the same function as the "filled" fields in Paradox
tables - i.e. it's the same capability, with just a different
paradigm.

Queries are ABSOLUTELY ESSENTIAL to any productive use of Access. If
you don't like using queries... you won't like using Access!