Re: Select Distinct in Table Field?

2007-05-25 Thread L. J. Head
) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Friday, May 25, 2007 11:43 AM To: arslist@ARSLIST.ORG Subject: Re: Select Distinct in Table Field? ** How many fields are in your join criteria? Could some Display only fields on form A, populated on GetEntry suffice? Also, now I'm curious

Re: Select Distinct in Table Field?

2007-05-25 Thread Thad K Esser
To arslist@ARSLIST.ORG cc Subject Re: Select Distinct in Table Field? ** Ahhere we get into some more specifics that I didn't present before I have Table A with unique records. Table B has a one to many relationship to Table A I have a Join between A and B...lets call it C...I need my

Select Distinct in Table Field?

2007-05-24 Thread L. J. Head
Is it possible to do a Distinct selection within a table field without leaving remedy? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are

RES: Select Distinct in Table Field?

2007-05-24 Thread Rogerio
: arslist@ARSLIST.ORG Assunto: Re: Select Distinct in Table Field? Yeathat's why I stated 'without leaving remedy'...I know how to do the DB View...I was looking for the ability without doing that -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED

Re: Select Distinct in Table Field?

2007-05-24 Thread Eli Schilling
@ARSLIST.ORG Subject: Re: Select Distinct in Table Field? Yeathat's why I stated 'without leaving remedy'...I know how to do the DB View...I was looking for the ability without doing that -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED

Re: Select Distinct in Table Field?

2007-05-24 Thread Axton
Bronzoni Aguiar -Mensagem original- De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Em nome de L. J. Head Enviada em: quinta-feira, 24 de maio de 2007 16:15 Para: arslist@ARSLIST.ORG Assunto: Re: Select Distinct in Table Field? Yeathat's why I stated 'without

Re: Select Distinct in Table Field?

2007-05-24 Thread Thad K Esser
PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/24/2007 12:14 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Select Distinct in Table Field? Yeathat's why I stated 'without leaving remedy'...I know how to do

Re: Select Distinct in Table Field?

2007-05-24 Thread L. J. Head
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling Sent: Thursday, May 24, 2007 1:34 PM To: arslist@ARSLIST.ORG Subject: Re: Select Distinct in Table Field? What disctinct values are you trying to select? Are you trying to do this within the table qualification

Re: Select Distinct in Table Field?

2007-05-24 Thread [EMAIL PROTECTED]
There is a process which requires a little workflow but it will work. Create a Unique Identifier field on your form as a checkbox with a value of Checked or any other value you want. Create a filter on that executes on submit which will perform a Push Fields and set the checkbox if

Re: Select Distinct in Table Field?

2007-05-24 Thread Scott Parrish
: Thursday, May 24, 2007 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: Select Distinct in Table Field? ** There is a process which requires a little workflow but it will work. Create a Unique Identifier field on your form as a checkbox with a value of Checked or any other value you want. Create

Re: Select Distinct in Table Field?

2007-05-24 Thread L. J. Head
: arslist@ARSLIST.ORG Assunto: Re: Select Distinct in Table Field? Yeathat's why I stated 'without leaving remedy'...I know how to do the DB View...I was looking for the ability without doing that -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Re: Select Distinct in Table Field?

2007-05-24 Thread L. J. Head
:)...ya beat me to the punch _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish Sent: Thursday, May 24, 2007 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Select Distinct in Table Field? ** A very nice solution if you are able

Re: Select Distinct in Table Field?

2007-05-24 Thread L. J. Head
to show a single record from A as opposed to the multiple records that you find in the Join _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 24, 2007 2:36 PM To: arslist@ARSLIST.ORG Subject: Re: Select Distinct