hello there
Info: I have a form on which is displayed information, customer code,
address and balance etc..
on that form i also have start of the current week, which is
displaying 29th march 2004 today for instance. this text box is
active, what i mean is when i press the plus or minus keys this text
box moves up and down one week.
now i also have on this form a subform of sales, which is a customers
weekly orders, this displays product code, mon, tue, wed, thur, fri,
sat, sun.
The problem: what i want to do is diplay the relevant information due
to the week start.
you see, a customer can change their order permanently, but i still
need to keep a record of it to display,
for example:
in my sales table for customer A100
Code StartDate
FCP 01/05/1999
FCP 15/03/2004
SSP 19/04/2004
so above you can see that this customers weekly order has changed for
FCP to take effect on 15/03/2004.
so what i want to do is display only the information which is relevant
to the weekly start date, i.e. this week for customer A100 I only want
to display the records of
FCP 15/03/2004
SSP 19/04/2004
and when i move through the weeks it will show only the relevant
information.
if anyone has any ideas please let me know, anything would be a great
help