one entery per date

[amna77]

is there a way that if i enter 10 or 15 records per day, so back in the table i will have record with date. i have on more field in the table, that field is going to capture only default fix value of 6.
so back in the table
date Hours fixfield
10/12/04 - 1 - 6
10/12/04 - 2
10/12/04 - 1
10/12/04 - 1.5
10/12/04 - 2

10/13/04 - 1 - 6
10/13/04 - 2.5
10/13/04 - 1

so basically doed not matter how many records i enter per day, but i want only fixvaluefield (6) once per date,
any idea how to do that.
thanks in advance

 

[SkipVought]

Hi,

What you need is 2 tables

First table has your fixvaluefield
[tt]
Posting Date
fixvaluefield
[/tt]
The second table has your hours
[tt]
Posting Date
Hours
[/tt]


Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[amna77]

thanks for reply, is there a way that in my fixed value field, i wanna put date in there by itself. like every day it should get a date in this format mm/dd/yy.
becasue that table is separate now for fix value.how would i get a date in there. just want one date per day.
thanks

 

[SkipVought]

You put the date in the Posting Date Field.

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}