Auto Fill a Field Based on Contents of Another

[Mike]

I have created a Db identifying projects I bid. It
includes multiple tables with relevant information.

One table is tbl General Contractor and includes the GC's
name and Phone Number. What I want is for the Phone
Number to automatically fill in to the tbl Projects Bid
when I complete the look-up of the GC field within the
Projects Bid table.

The structure of the relationships is numerous sub tables
feed into the Master table Projects Bid.

Thanking you in advance

Mike

 

[Douglas J. Steele]

You can't do this using tables. You must use a form, and put logic in the
AfterUpdate event of the GC field.

 

[Mike]

Thanks. I'll try to figure that out.
Let me ask this.
I set up the Master Tbl Projects Bid to look up the Field
Contents of the sub Tbls for the GC.

I produced a form through the Wizard that utilizes the
Fields in the Tbl Projects Bid. When I go to input the
data into the form, it shows the current lookup data
within the sub table. I would like to be able to enter a
new company name if not already contained within the sub
table. I have established relationships between the two
already. When I go back to the table to view if the new
Company name is there, it is not.

Does this process require code as well or am I not
setting up the relationships correctly?

Thanks

 

[Tim Ferguson]

What I want is for the Phone
Number to automatically fill in to the tbl Projects Bid
when I complete the look-up of the GC field within the
Projects Bid table.

No you don't. When you want to see the phone number you add it to the query
on which you are basing the form or report or whatever.

You are using a relational database -- use it relationally!!
((c) John Vinson 1999, 2000, 2001, 2002, 2003, 2004...)


Hope that helps


Tim F