LookUP

[Kjonnnn]

I created two tables regarding membership dues.<br>Member Names - 1st Table<br>Member Donantion - 2nd Table<br><br>The 1st table contains member names only (with a key)<br>The 2nd table contains various fields to input money amounts given by members.<br>The 2nd table name field lookups up the name on the 1st Table BUT it only shows the first name.<br><br>It the properties it says that 3 columns are included (key, firstname, Lastname.&nbsp;&nbsp;But only the first name will show up.<br>What can I do.<br><br>PS - A Relationship for the two name fields has been established.

 

[Melee]

I may not be understanding the entire issue, but it sounds like a SQL statement might be the solution -- then again, I could be totally out to lunch--<br>&nbsp;[Table1]![NameLast] & &quot; ,&nbsp;&nbsp;&quot; & [Table1]![NameFirst]

 

[samara]

there's something i missing about your problem,<br><br>&nbsp;You have a &quot;Name&quot; field in the 2nd table SO how you want it to show you two fields from the 1st Table. <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

 

[Kjonnnn]

From the lookup properties of the name field, in 2nd table it allows you to look up more that one column.<br><br>Now both names, first and last, show when u open the menu for that name field, but only shows first name after its been selected.

 

[samara]

Yes man,<br>it can display (as many fields as you want), but it will only save one of them (the one which is bound). <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

 

[DreewToo]

It sounds as if your settings for column width's is not to your goal.&nbsp;&nbsp;If you'd like to view the full name after selecting it from the combo box, the field that currently displays just the first name should be something along the expression that Melee proposed, <br><br>FullName:[Table1]![NameLast] & &quot;, &quot; & [Table1]![NameFirst]<br><br>, and the column count setting 2, with bound column to 1, and column width to 0&quot;;2&quot; (or so).&nbsp;&nbsp;This way, the full name of the selected person would be displayed, rather than just the first name.<br><br>HTH,<br>Drew