Linking forms to tables

E

Ed

I have 8 tables created for my database: catalog numbers, countries,
FFR#,Part#, Rat_old, Return Authorization, Sales force, and Sales personnel
by name. Ive created a form for the Return Authorization Table with drop down
boxes. My problem is the drop down box on the field "Returned From" when i
push the drop box it lets me choose any sales rep that i want to select but
when i select it it only brings up or show just the rep name and not the
addresses, state, and zip. The Sales Rep table has all of the fields that i
want to show on the form but will only show rep name when i select it. Can
someone help?
 
C

Chris

Set the columnCount property to whatever number of fields you want to have
displayed.

HTH

Chris
 
E

Ed

ive done that already when i created it the count was already set at 7 still
not working for some reason do you think it might be the relationship?
 
R

RuralGuy

It sounds like your form needs to be based on a query that includes
both the "Return Authorization" and the "Sales Rep" tables to display
as you desire.

I hope you are aware that using spaces or special characters in *any*
name will *always* give you unexpected grief. Much better to use
CamelFontNames or Under_Score_Names avoiding special characters and
reserved words.

I have 8 tables created for my database: catalog numbers, countries,
FFR#,Part#, Rat_old, Return Authorization, Sales force, and Sales personnel
by name. Ive created a form for the Return Authorization Table with drop down
boxes. My problem is the drop down box on the field "Returned From" when i
push the drop box it lets me choose any sales rep that i want to select but
when i select it it only brings up or show just the rep name and not the
addresses, state, and zip. The Sales Rep table has all of the fields that i
want to show on the form but will only show rep name when i select it. Can
someone help?
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
A

Albert D.Kallal

Ed said:
I have 8 tables created for my database: catalog numbers, countries,
FFR#,Part#, Rat_old, Return Authorization, Sales force, and Sales
personnel
by name. Ive created a form for the Return Authorization Table with drop
down
boxes. My problem is the drop down box on the field "Returned From" when
i
push the drop box it lets me choose any sales rep that i want to select
but
when i select it it only brings up or show just the rep name and not the
addresses, state, and zip. The Sales Rep table has all of the fields that
i
want to show on the form but will only show rep name when i select it.
Can
someone help?
Click to expand...

Yes, build a sub-form to display all of those other fields. I explain how to
do that here:
http://www.members.shaw.ca/AlbertKallal/Articles/fog0000000005.html
 
Top