i need help about my project plz

[ga3la]

hi everyone i have project to do, but really i'm very confiose for much things i must to do. for that i come here to ask for help if anyone have little time and be patient



well let me talk about the important:

i do the basic things, and left the complicate things for search and learn and help from you.

what i'm looking for:

i have database with customers, there are two tables one loyal customers and other free customers, everything i need just applicate of loyal customers.

- i need like warning msgbox every 6 mounths show message box warning there is some customer make 6 mounths and need make notes. in same time the warning stay active because maybe i wasn't able to check the program in the same day that have some customer already make 6 mounths, stay apear till i make notes and in same time already start counting for next warning 6 mounths.


P.S : if you see the loyal customers, there are some customers have two contrat or more just for same customer


thank you so much for by attention and try help, really i need finish that in small period

[ga3la]

hi again here you are the file i made just left the things i asked.

[jbarrum]

Boy you have gotten off to a bad start. You are going to create a normalization problem for your data if you store customers in two different tables. You need to store them all in one table and and have a field for customer type (Loyal, Free, etc...) Store your customer types in a seprate table and make the primary key of that table a forign key in your customer table.