Hi All,

My Table Structure :

CREATE TABLE [dbo].[auto] ( [id] [int] IDENTITY (100, 2) NOT NULL ,

[HS1] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[filename] [char] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

insert...

It's definitely not about forms. I already know how the form would look like and how the connections are set up to databases.

I need to come up with a...

This is actually very similar to a customer-order management system (one-to-many relationship) used on websites like amazon or bestbuy.

Each user can buy what he wants to and check out. Later...

What you said is exactly right when you know the dates beforehand.

How can I do a similar thing if I don't have the dates with me (The employees can choose...

Yes it's the first one..and the number IS the problem..it is going to be very random.

This is actually a management system for employees where the employees enter the days they...

Hey,

Sorry couldn't post back earlier- was busy with my project submissions- I did not exactly use the views provided by you. Instead, I just added 2 columns for the 'date...

Thanks a ton for the help.

But the table I'm using is a bit different. It looks like this:

ProfileId HireDate ...

To say exactly, 5 seconds was just a way to get it as a confirmation of what I need-a test.

This is what I want- I'm building an employee management system...