Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>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
Yes, as Mr. Berntson said, it would be a grid in grid. But, I feel it is fun to do. Actually, I learned how to do a grid-in-grid-in-grid. You need to create the most inner grid first. [KEEP A COPY OF IT.) Then, drop it into a column of the mother grid. Also, add a command button in the column to be used to blow up the column to the same size of the grid (also shirnk other colunm's width to 0). Then use the click event of the header of the blowed column to do the shirking and restore all other columns. Have fun!
If you would like an example, please email me.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement