Hi - Here is my problem. I need to add a new record with a date. I then need to add the same record with the date for next week, the week after, etc... for the whole year.

Is there anyway ofr automating this?

Thanks!

In the FAQ noted below there is a thread called "Making a "COPY" of a record?"

I think this will provide the solution you are looking for.

The original thread is:

Thead: http://gossamer-threads.com/p/001592
Topic: Making a "COPY" of a record?
liverpool - September 20, 1999

You could also see if there are any other alternative solution in the DBMan FAQ.

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/

Hi - Thanks for your response. The criteria has changed. When I log in I have this statement:


print qq|<META HTTP-EQUIV="Refresh" CONTENT="0; URL=$db_script_link_url&view_records=1&Date=$date&sb=8&so=descend&ww=1"><BR>\n|;

This gives me a listing of all records with todays date. I need to add another criteria for example all listing with todays day or todays day. The day I can get but how would I add it to the above statement. My thinking is if I do not add a date and only a day, for example monday, every monday this entry will popup and there is not reason to duplicate the entry.

I first thought something like this


print qq|<META HTTP-EQUIV="Refresh" CONTENT="0; URL=$db_script_link_url&view_records=1&Date=$date&sb=8&so=descend&ww=1|| Day = $date"><BR>\n|;

Day is a field in my database and $date gives me the day - however as you can guess this does not work,

Thanks for your help!

Avi