This looks similar to my Products table in Which I have:

ProductCategoryID

ProductID

ParentID (The ProductID of this Product's Parent)

Now, the Parent ID points to it's Parent Product (this does not mean it's...

I wasn't sure if your last sentence was sarcastic or not...but sure, I will not submit the URL...

Anyway, I tried the Access Data Project...

No, no, no...please leave the past (Access) behind you .  With that in mind, create an Access Data Project (ADP) and change it's data...

Ok, thanks for all the input, I'll look into the Decimal data type more and make a decision. 

Hmm, well the Decimal data type is still larger than SmallMoney (although I'm really not concerned about 1 Byte ).  SmallMoney comes in at...

Ok, I guess I never took the time to look into the Precision / Scale of Decimals.  It seems like that would work.  Could you elaborate a little on Precision...

Ok, what I mean is this...

If I try to create a table, or even a Temp Table for that matter within a Function, it will not allow it.

Create...

Point well taken

Hmm, what about using an XMLReader and the Command.ExecuteXMLReader instead?  I believe (but I'm not positive) that you can release the connection since once the xml is retrieved, all you're...

Sounds interesting...no doubt it will come with a performance penalty

Ok, why not just make 2 Forms.  one will be the Master Form (think of it as the Test's Heading).  Then you can also have a Details Form.

On the Details...

Why an Indexed View?  Can someone explain the differences between the indexed view and a Trigger?

1.)  Is an Indexed View faster?

2.)  What are the advantages of the View over a...

Hmm...there's an easier way...

Once you have given the Connection Object to the ADO Command, it can auto-magically retrieve the parameters from the DataSource (however, this does not work with Sybase...

Well, I'm sorry but I can't help you there.  Due to Licensing, we've never been able to Develop any Crystal Reports for the Web.  At one point, my company almost...

Ahh, you are at a very pivitol point...the Begining!  This is also the most important point when Developing Reports...coming up with the Strategy.

A couple of years ago, I started playing...