I have been looking around, and that is what I think I have to do as well.

I just didn't know where my data would come from to insert into my...

Unfortunately, I can't use the UniqueIdentifier field.  I have to keep the ID as an Integer.  (Again, this is the 3rd party constraint.   )

At the risk of sounding like a newbie, I am not sure.

The two tables are identical, except for the following:

The EMP_GRP_ASS has a unique key EMP_GRP_ASS_SK, which is...

WOW!  Way cool site!

Thanks a million!

Thanks a Bunch!

I was afraid that that was what I needed to do.  (In fact I had already coded it that way.)

That 2005 thing is yet another good reason to upgrade SQL.

Thanks,...

I was using Error # 547 as an example.  (This is what MS SQL Help had as an example.)

If I recieve an error, should I just pass to the user...

Unfortunately, I can not include the tblSavedForm.FormID in my grouping.  I may have 2 different FormID's that match my ClientFormTitle criteria.

Sorry, Remi.

I don't want to Byte the Hand that feeds me.

When I said that your solution was a little more than I needed at the moment, I was refering to...

Simple enough.  Thanks!

Remi's solution is a little larger than I need right now.  (Besides, I have a function that will return a Text field as rows broken by a character.)

I had posted a similiar question back in March, and when I searched the forums, they pointed me in the correct direction (I think).

One of things that I will have...

Just remember Bryan - henceforth if tanking up on caffeine doesn't do the trick - SSC/remi (used interchangeably here) always will!

SSC/remi ->...

All right, you guys.  I feel like a "Newbie" now. 

I should have thought of the "sub-Query".  Guess I need more caffiene. 

I have not.  I thought that Top 1 will only return 1 row.

This is my dataset that is returned:

File_ID

Branch_ID

Data

Data

1

2

hghghg

rtrtr

1

3

sdfsdf

sdfsd

2

9

hghghg

rtrtr

3

12

sdfsdf

sdfsd

3

43

hghghg

rtrtr

4

23

sdfsdf

sdfsd

I would like to only get back 1 row per File_ID.

I have used Visio to create my "maps" of tables.

Is there a way to get it to give me a list of my tables, fields, etc... ?  If so, where...