np,
Rename the field called [Company] to be called [Related Company]. It will hold the [Record ID#] of the Company record.
But you do not want any of your users to see that [Record ID#] field. So that is a perfect opportunity to set a proxy for the field[Related Company]. So edit the field properties for Related Company] and select Company Name to be the Proxy field.
Then make sure that you're only using the field Company Name on all forms and on all reports because you don't want your users to be looking at Record ID numbers.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------