Table Design Confusion

[drunkenneo]

Hi All,



I am in a big confusion, here need your help:

I have list of Partners say 50 in numbers, all have different preferences of sending the mail e.g 4 of them need on monday and other 5 need on Tuesday, and also there are some partners who were needed to send mail everyday.

On above preferences, Partners may communicate us that they have changed the day of sending mail say from Monday they have changed to Tuesday.

My confusion How should i go about designing of tables in case like this and also the interface i need to give to user so they can record the changes? Please suggest

[ranman256]

Sounds simple...
table: tPartners
If they only want mail on 1 day a week, fields:

ID (autonumber)
PartnerName
EDay (Mon,Tue,Wed....)


As for interface, select the table then click instant form button.
I'd make a combo box (use the wizard) , tell it to add data yourself , and enter the 3 char. days of week; Mon, Tues,...

You can also set a combo with the patner names for quick filter on the form. (but it may be too advanced)

[drunkenneo]

In addition to above point i have some partners who were sent 2 days a week also