Table Help!!!

[banderson06]

I have a charge table in a difficult database. I had it created for me. What i am trying to do is in the charge table there are 8 fields. 1 field named Ven#, 2 field named Ven Name, 3 SCH#, 4 Sch Name. The Ven# and Ven Name fields are linked to another table. The SCH# and Sch Name are from a query i set up to pull the information from another table. I am trying to make it when i select the Ven# ii would like for the Ven Name field to fill-in automatically. The same with the SCH# field when i select the SCH# i would like it to fill-in the sch name. Can some help me try and figure this out? Any help would be much appreciated.

 

[cuttsy]

I don't know what ven and sch are but it does appear to be the wrong way to go about this. If you have a table with a Ven# and sch# that are foreign keys then you shouldn't duplicate data by holding ven name and sch name in this table as well as wherever they are linked from.

i.e. if you had Table_Ven(Ven#, Ven_Name) Table_Sch(Sch#, Sch_Name)

Table_Charges(Ven#, Sch#)