I want to create a grid which displays 4 columns, Position, First, Last, Phone for a contacts list(who does what job function). I have 4 tables involved: Agency - which agency a person works for which will be displayed outside the grid; Contacts - which contains the agency code, position code, and person code, this table relates to the other 3 tables; Position - contains the position code and description text; and finally, Person - contains the person code, first, last, phone etc. Overall I want the data displayed by Agency, Position, then Last (since one person can hold several positions).

I would like the Agency name to display outside of the grid, and the grid to contain the Position.position field, Person.first, Person.last, Person.phone fields in the columns based on the info in the Contacts table.

I've tried setting the Grid properties: LinkMaster = Agency, RecordSource = Contacts,RelationalExp = agencycode; Column ControlSources to Contacts.positioncode (for Col1), and Contacts.personcode (rest of the Cols) and the Textbox ControlSource to Position.position, Person.first, etc. to no avail.

Can this be done? I quite new to this and haven't seen anything about displaying fields from multiple tables in a grid.

TIA