Two Columns into One Field

[LouieGrandie]

Have a table with two fields, initials and name, say JS and John Smith. I have a master file with the field Salesperon and I want to make the first table the data source. However I want both JS and John Smith to populate the field in the master file when the record is selected. Is that possible and how would I do it? My second option is on a form I have a field which displays the initials selected and I have another field where I want the name that goes with the initials to display. which is possible.


Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[dhookom]

Your question is a bit confusing without you providing some additional information about your table and field names and relationships.

Do you understand primary and foreign keys and relationships? In a properly designed database application, a person's name should only be stored in one table in one record.

Duane
Hook'D on Access
MS Access MVP

 

[LouieGrandie]

Figured it out.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc