Oh somebody help before I have to take this mouse hostage!

[Guest]

I have my tables:
Customers
Vendors
Salesmen
Models
RA Details

Now I have populated all of my tables except the RA Details - I think cuz it
is my junction table to get all my tables to have a "nice relationship" BUT I
want to make a form from my RA details table - which will have all the
returns for multiple vendors - THE PROBLEM:
I was told not to duplicate info so I need to be able to enter the customers
phone # (which is our account number system) and have the customer phone #
name address city state and zip entered into my form - do I have to do this
individually or can I just look up the phone number and have all the other
needed fields populated by this info from the customers table?

ALSO:
I need to be able to do the same thing with the vendors - type in the vendor
name and once I select the correct name from the look-up it will hten
populate the shipping address of the vendor

I would appreciate any help!

 

[tina]

do you mean to just *display* the customer and vendor data? or are you
actually saving that data into the RADetails table? if the latter, you
shouldn't be, as that *is* duplicating data, and a violation of
normalization rules. only the primary key values from the customer and
vendor tables should be *saved* into the RADetails table.

to just *display* the customer/vendor data on the form: use a combo box
control to enter the customer phone number in the form. base the RowSource
on the Customers table, and make sure the fields you need to see are
included in the RowSource. you can set the ColumnWidths of those fields to
zero (0), so that they don't show in the combo box droplist - but they'll
still be "available" to the form. then add UNbound textbox controls to the
form to display the customer data. set the ControlSource property of each
textbox to show the value from a specific column in the combo box, as

=[ComboboxName].[Column](n)

and replace the "n" value with the index number of the column. note that
combo box columns are zero-based, so the first column (going from left to
right) is (0), the second column is (1), etc.

use the same solution to display the vendor data.

hth

 

[Guest]

Tina, I will try that as soon as I get back to work. Thanks for all your help.