>>>I posted a message earlier and just saw that I got a response. Unfortunately I'm a newbie to this UT and accidentally hit the "remove" tab before reading the message and now I can't find it anywhere. Ugh.
>
>>Click on 'MailBox' icon to get all responses to your message.
>
>I did when it said "1 Reply", the reply header then displayed in the lower left frame, then when I accidentally hit the "remove" tab, the message disappeared and no new messages appeared after hitting the mailbox icon again. :-(

here's a copy:
>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.
>
This is a good time to take a look at Views and the View Designer -- this is ideal for multiple tables in grids.

The anonymous bureacrat (bruce campbell)