**

Hello List,

I have a question regarding the best possible method to do the following? We are currently using a completely custom HD and Asset Tracking application. Each Application has its own set of information that is gathered but there is one field on both applications that contain the same information for some records. I would like to link that designated field that is located on the HD forms to the designated field on the Asset form. So when a search is performed from the HD form it would pull up the record in the HD form as well as show the the record in the Asset application that contains the record with the same results in the key field.

ARS 6.3
SQL Server 2000
Windows Server 2003

Thanks in advance

20060125This posting was submitted with HTML in it

Abdullah:
As long as your "designated" field is unique across records, you can
create a join form between HD and Asset Tracking forms with this field
as the key so that searching on the join form gives you info on both
forms.

There are other ways of viewing merged info from the two forms, but a
join would be the best solution.

On 1/28/06, Abdullah Baytops wrote:
> **
>
> Hello List,
>
> I have a question regarding the best possible method to do the following?
> We are currently using a completely custom HD and Asset Tracking
> application. Each Application has its own set of information that is
> gathered but there is one field on both applications that contain the same
> information for some records. I would like to link that designated field
> that is located on the HD forms to the designated field on the Asset form.
> So when a search is performed from the HD form it would pull up the record
> in the HD form as well as show the the record in the Asset application that
> contains the record with the same results in the key field.
>
> ARS 6.3
> SQL Server 2000
> Windows Server 2003
>
> Thanks in advance 20060125This
> posting was submitted with HTML in it


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org