AutoFill Field

[cazz]

Hi

I have a database with about 6 tables - each table is connected via the
primary field in table no 1 - request no, one to many relationship.
All tables also have one other field in common - software title.

What I need to do is to automatically fill in software title field in
each of the tables if the request no selected is the the same as in
table 1?

Anyone any idea's??

[Mike MacSween]

"cazz" <ca****************@yahoo.com> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com...

Hi

I have a database with about 6 tables - each table is connected via the
primary field in table no 1 - request no, one to many relationship.
All tables also have one other field in common - software title.

What I need to do is to automatically fill in software title field in
each of the tables if the request no selected is the the same as in
table 1?

Anyone any idea's??

Put software title table no 1. Or a lot better, have a table called
softwaretitles, with an ID field and and text field, and set up a one to
many relationship between that and table no 1.

[Ed Robichaud]

One of the main reasons for "relating" tables is to eliminate the
duplication of data. You don't need, and should not have, the field
[software title] in each table. A query containing the ONE table that has
the [software title] would be used as a record source for forms/reports (or
DbLookUp) anytime you need to display that value.
-Ed

"cazz" <ca****************@yahoo.com> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com...

Hi

I have a database with about 6 tables - each table is connected via the
primary field in table no 1 - request no, one to many relationship.
All tables also have one other field in common - software title.

What I need to do is to automatically fill in software title field in
each of the tables if the request no selected is the the same as in
table 1?

Anyone any idea's??