>>>I created a view based on two tables,where Both tables have one common field name. In the form level how can I get the related table name of those fields.
>>>
>>>Nabil
>>
>>fp usually uses a '_a', '_b' at the end of the field names... you can rename the fields when creating the view. (select cust.cust_id as customer_id, order.cust_id as ord_cust_id from cust, order.....)
>
>Can I get the table name without renaming the fields ?
>
>Nabil

i don't think so. the safest way is to rename the fields in the select statement.