Customer sql view

system · October 24, 2008, 9:33am

I meant creating a concatenated field in your existing view that would be
your unique field for access.

Your view would look like

Select company + CAST(custnum AS Char), custid, name ...

From Customer

Daniel

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, October 24, 2008 9:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Customer sql view

Do you mean create a new sql view that just pulls up the one company or do
you mean create a field in the query that identifies each record?

Thanks,

Jasper

________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Daniel Laidig
Sent: Friday, October 24, 2008 9:12 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Customer sql view

You could just create your own unique record in your view. You could create
a field: company+cast(custnum as char)

Daniel

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups
<mailto:vantage%40yahoogroups.com> .com<mailto:vantage%40yahoogroups.com>]
On Behalf Of
Jasper Recto
Sent: Friday, October 24, 2008 9:07 AM
To: Vantage Groups (vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
.com<mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Customer sql view

I created a customer sql view so I can link it into Microsoft Access.

The problem I am having is that we have 2 companies in Vantage. Each has its
own CustID. The customer number is automatically generated when you create a
new customer. The first customer I created in the first company gets a
CustNum of 1. The first customer I created in the second company also gets a
CustNum of 1.

When I link the customer view to access, it asks what field uniquely
identifies each record. I would normally pick the CustNum but that will not
work. Its actually a combination of the CustNum and the Company.

How can I get the link to work in Microsoft access? If I choose the CustNum
as my unique Identifier, all records show but it does not distinguish
between the different companies.

Does this make any sense? Any ideas?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · October 24, 2008, 9:07am

I created a customer sql view so I can link it into Microsoft Access.

The problem I am having is that we have 2 companies in Vantage. Each has its own CustID. The customer number is automatically generated when you create a new customer. The first customer I created in the first company gets a CustNum of 1. The first customer I created in the second company also gets a CustNum of 1.

When I link the customer view to access, it asks what field uniquely identifies each record. I would normally pick the CustNum but that will not work. Its actually a combination of the CustNum and the Company.

How can I get the link to work in Microsoft access? If I choose the CustNum as my unique Identifier, all records show but it does not distinguish between the different companies.

Does this make any sense? Any ideas?

Thanks,
Jasper

[Non-text portions of this message have been removed]

system · October 24, 2008, 9:12am

You could just create your own unique record in your view. You could create
a field: company+cast(custnum as char)

Daniel

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, October 24, 2008 9:07 AM
To: Vantage Groups (vantage@yahoogroups.com)
Subject: [Vantage] Customer sql view

I created a customer sql view so I can link it into Microsoft Access.

The problem I am having is that we have 2 companies in Vantage. Each has its
own CustID. The customer number is automatically generated when you create a
new customer. The first customer I created in the first company gets a
CustNum of 1. The first customer I created in the second company also gets a
CustNum of 1.

When I link the customer view to access, it asks what field uniquely
identifies each record. I would normally pick the CustNum but that will not
work. Its actually a combination of the CustNum and the Company.

How can I get the link to work in Microsoft access? If I choose the CustNum
as my unique Identifier, all records show but it does not distinguish
between the different companies.

Does this make any sense? Any ideas?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · October 24, 2008, 9:17am

Do you mean create a new sql view that just pulls up the one company or do you mean create a field in the query that identifies each record?

Thanks,

Jasper

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Daniel Laidig
Sent: Friday, October 24, 2008 9:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customer sql view

You could just create your own unique record in your view. You could create
a field: company+cast(custnum as char)

Daniel

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Jasper Recto
Sent: Friday, October 24, 2008 9:07 AM
To: Vantage Groups (vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Customer sql view

I created a customer sql view so I can link it into Microsoft Access.

The problem I am having is that we have 2 companies in Vantage. Each has its
own CustID. The customer number is automatically generated when you create a
new customer. The first customer I created in the first company gets a
CustNum of 1. The first customer I created in the second company also gets a
CustNum of 1.

When I link the customer view to access, it asks what field uniquely
identifies each record. I would normally pick the CustNum but that will not
work. Its actually a combination of the CustNum and the Company.

How can I get the link to work in Microsoft access? If I choose the CustNum
as my unique Identifier, all records show but it does not distinguish
between the different companies.

Does this make any sense? Any ideas?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · October 24, 2008, 9:20am

Will it let you choose CustNum or error out? If it allows, maybe accept
that and then make two baseline queries that filter off each company
(CustomerCompanyA and CustomerCompanyB) with the Company field. Then all
further query development can use these queries instead of the Customer_View
when accessing the customer table.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, October 24, 2008 8:07 AM
To: Vantage Groups (vantage@yahoogroups.com)
Subject: [Vantage] Customer sql view

I created a customer sql view so I can link it into Microsoft Access.

The problem I am having is that we have 2 companies in Vantage. Each has
its own CustID. The customer number is automatically generated when you
create a new customer. The first customer I created in the first company
gets a CustNum of 1. The first customer I created in the second company
also gets a CustNum of 1.

When I link the customer view to access, it asks what field uniquely
identifies each record. I would normally pick the CustNum but that will not
work. Its actually a combination of the CustNum and the Company.

How can I get the link to work in Microsoft access? If I choose the CustNum
as my unique Identifier, all records show but it does not distinguish
between the different companies.

Does this make any sense? Any ideas?

Thanks,
Jasper

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links