Hello All, this is probably a real stupid question but I am having one of those days...

Ok so I am trying to make a staff availiability database, I already have a relational DB for the staff and now I want to log their avaliabilities. So a somebody with id number xxx phones up and says:

"Hi its suchandsuch, I am available to work on the 29th on an early or a night shift"

So I have created a new file (availability) with id_number, time_avail and date_avail in it, and then linked stuck a portal in my main file to avail_time and avail_date

now the problem is, how do I attach multiple times to 1 date? and see them appropriately in the layout?

Any help appreiciated...

Cheers all

If I understand you correctly you will just need another related record for the other time available on the given date.

HTH

OK,

I am with you on just creating a few more related fields, thats sorted

Now, when I insert all the data into my portal, how do I create a new availability for that person that is:

the portal allows entry for all data for say

date : 26/8/2003

available for : late, night, afternoon

now you are also available for 27/8/2003, how do you get it to offer a 'blank' portal that is not the previoulsy entered data..(I know that entering data will create a new record in the related file, but I dont want the user to see this)