Time event

[Toni]

Ok, I'll go straight for what I need.

I'm working on a database in which there is a time limit in creating a record. The record has to time fields. One is entered manually and shows an event that will occur at that time on a precise date (kind of TV show let's say). The other time field is automatically entered, and it has the creation record time.

Now if the creation of the records happens after the time of the event that the record shows, this record shouldn't be created.

Is there any way to triger the prohibition of creating the record at the time that was verified this is happening after the time limit? Or if it can't be triggered any other solution would be apricciated.

Thank you, Toni

[IdealData]

Try using global fields to hold the entries, but this means you'll need to script the data entry, however you get more control !

If the entries "time out" then clear the data, otherwise create a new record and write the values from the globals.

[Toni]

Hmm, global fields ..., Mark I would need more help then, because I'm not thet good with global fields :.

Can you describe any example?

You see, I have an "A" event which occurs at a specific date and time. I need to make a bill to the event, but never in no way after the time it is going to take place. So I have "ADate" and "ATime", on the other hand "BillDate" and "BillTime".

Would be gratefull for any further help, Toni