Form lookup field

[advpay]

Hi,<br><br>Bill Type - table<br><br><br>AutoNumber BillType Billing Code<br>&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Regular Bill REG<br><br>I have a form with a lookup to this table but I don't know how to get the description field 2 or 3 to be included to view the description...but Only store AutoNumber field 1; in my orders form.<br><br>I have this:<br>SELECT [Bill Type].[AutoNumber] FROM [Bill Type]; <br><br>Thanks<br><br>

 

[DreewToo]

Bound column=1, <br>columns=3, <br>column width=0&quot;;.7&quot;;.3&quot;<br><br>Combos row source should be something like this:<br><br>SELECT [AutoNumber], [BillType], [Billing Code]<br>FROM [Bill Type];<br><br>There are a couple cautions I see, your table name seems to closely match one of your fields, which could easily confuse access.&nbsp;&nbsp;The same holds for a field named 'autonumber'. <br><br>Drew

 

[THoey]

I am not sure I am understanding right, but if you want to view the valus of all three fields, you need to &quot;select&quot; all three fields:<br><br>SELECT [Bill Type].[AutoNumber], <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Bill Type].[BillType], <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Bill Type].[BillingCode] <br>FROM [Bill Type]; <br><br>If this is what you are trying to do, I will make one suggestion.&nbsp;&nbsp;&nbsp;You should change the name of the &quot;autonumber&quot; field.&nbsp;&nbsp;&nbsp;&nbsp;This is a reserved word, and even though Access seems to have let you use it, it could cause some unexplainable problems later.<br><br>Hope this helps... <p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>

 

[advpay]

Ok thanks...I change the field names<br><br>BillNumber<br>DescriptionType<br>BillCode<br><br>I want to see these other fields in the drop down list from my Orders form but don't want to store it that way in the Orders table<br><br>Orders Form drop down -<br><br>Bill Number&nbsp;&nbsp;&nbsp;&nbsp;DescriptionType - description..not see this <br>1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Regular Bill&nbsp;&nbsp;&nbsp;(this is what I want too see)<br><br>This is what I want to store in the Orders table:<br><br>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;not all the other fields.<br><br>Thanks

 

[advpay]

figured it out...for some reason I had set my table.billtype for a lookup...oh well