yes. This is what I was looking for.

Sam

Thanks, Edwin.

I didn't post the rest of the calling SP, but I am outputting the Address table PK as PrimaryKeyValue there. So I want the incoming PK from the Facility...

hey thanks, Gary. I had been looking for the debug feature in QA and couldn't find it. Ever feel like you're ice skating and your skates keep heading out from...

never mind. I finally found it. It was a typo. (That only took 3 days to find!!!)

Sam

yes it does, thanks. It actually convinces me that this is way to dangerous for me and requires a real DBA. (where do you find those criters?)

SMK

Deni: to clarify: I need to remove replication from a database and I was wondering how to do that.

Thanks,

SMK

Wow thanks, Frank. That did it. It's usually the little things like that that consume great quantities of time.

SMK

That's the info I needed. Thanks.

SMK

Thanks. I have around 20 such columns. So is the most efficient thing to do to make 20 joins? This is actually a report.

SMK23

Thanks, Kathi.

Very helpful links. I have a MS SQL DB and I was wondering if PHP programmers could access and program against it. It looks like they can.

Have a...

Yonoah:

You need to create a form with a subform. The form your user is opening to enter the suspect may be appropriate to use as a subform.

The recordsource for...

Thanks, guys.

I really appreciate the input!

Smk

By far, the most helpful resource I have found is Microsoft Access Developer's Guide to SQL Server by Mary Chipman and Andy Baron, available on Amazon.com

Your topic is a bit...

Thanks for your patience. I've got it working finally.

I will plan to get more familiar with BOL. I have used it some.

SMK

SQLBill: thanks for your help. THe FROM clause is there because I don't know what I am doing. I will remove it.

I have figured out the problem with the...