field from another table...

[doran_doran]

Form Name: frmgroups

I would like to show couple of fields from another table. Most of the field in my form is from one particular table called tbl_groups. However, I need to show phone number from another table called tbl_admin. Field name for phone is [phone].

frmgroups is based on tbl_groups.

Prompt respond will be appreciated.

tbl_groups has a field call primary_administrator. tbl_admin table has the same value for the name for that primary_administrator is contact. I did relationship.

Help will be appreciated.

Dianna Jamil

 

[Travis]

Two possible methods:

1. Create a SubForm

2. Use a Listbox control

 

[Ringers]

Add your text field or label where you want the phone number to display. Then select the properties for this item and link it's source to tbl_admin.phone.