Auto Fill a Field Based on Contents of Another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 01 Feb 2004 14:53 GMT

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

Reply to this Message

Douglas J. Steele - 01 Feb 2004 15:50 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> I have created a Db identifying projects I bid. It
> includes multiple tables with relevant information.
[quoted text clipped - 11 lines]
>
> Mike

Reply to this Message

Mike - 01 Feb 2004 16:39 GMT

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

>-----Original Message-----
>You can't do this using tables. You must use a form, and put logic in the
[quoted text clipped - 17 lines]
>
>.

Reply to this Message

Tim Ferguson - 01 Feb 2004 19:05 GMT

> 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

Reply to this Message