AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question I have two tables - the first contains user name and address - key is UserID - the second table contains group names that a user in the first table can belong to and also has a UserID key. On a single form I want to display the name, address and group name. I can make this work by using a subform to display the group name. However all I want is the group name displayed in a simple text box, just like the name and address. I've attempted to use a query as the source for the group name text box to no avail. I have programmed other 4GL databases and this is done by simply setting the source of data for the text box to the table identifier:field. Is there no simple way to accomplish this in Access? Thanks for your time.
Answer If there a person can only belong to one group, then you can do this with a query. However, if they can belong to multiple groups then you should use a subform. You can format a subform so it doesn't have borders or record selectors so it can appear as just some text boxes.
You can also base the form on a query and put everything n text boxes, but then you would have to navigate to each record to see the different groups.
