Thank you,

I've been reviewing it and there are some things I can definately use.

The down side to using some of these for select, delete, etc... is (I think) I have...

This is off topic and I apoligize.

I see that you created an SQL query on the fly and executed it.

Would you know where I can find a good (complete) example...

I'm not sure I follow.

If I am the owner of Table_B and have reference permission to Table_A.

I can use a column in Table_A as an FKey to my Table_B?

Is this...

Thank you,

I will read up on unique constraints.

Looks like it'll work great.

Thanks again,

If I open the View from the Mangement Console/Studio I can add/edit rows, no problem.

If I link to in in Access, I can add/edit rows from tables but not views.

Well guys,

I have to say thank you. It took a bit but I can put the funcation (i.e. GetDate()) into the View directly. Again, thank you.

However, most of...

It is an open query with a variable, I'm new at this so.... it may not be the most conservative choice of coding.

Declare

...

Fantastic!!!!

On to the next step.

Thank you,

How about this instead?

P.S. for some reason it doesn't work?????????

It keeps saying I have an error near the last ")"

Insert Into dbo.tbl_PosPay_xfer_File_Test

(

ACCTNUMBER

, ITEMNUMBER

, AMT

, ITEMTYPECODE

, PAYEE

, REFERENCENUMBER

, Date_xfer

)

Select

ACCTNUMBER

, ITEMNUMBER

, AMT

,...

Sorry, I'm just very new to this and still learning SQL and all of its related commands.

Here is what I have and would like.

I currently have a view with a...

I am very new at this and I honestly have no idea what the commands you show will accomplish.

Thank you,

It took some playing but I got it working.

Now the real work begins.

I use both form and datasheet.

I can see how this might work with a form. I could either have one update statement for each text/check box for one for...

Sorry about bumping this up.

Does anyone else have this problem?

How do they solve it?

Thank you,

It is going to take me a bit to figure why/how the Coalese works with the reverse, etc..

In the meantime since it saves on performance I have switched to it....