I currently have a database held in Access with the following tables:

Frequency
Weekly
Fortnightly
PayDay
Monday
Tuesday
Wednesday
Thursday
Friday
YesNo
No
Yes

Each tables uses an auto number to generate a unique ID startiung from 1. I have a main table called Clerical which has fields pointing to the relevant table holding the information i require. My problem is displaying the relevant text to that pointer, also allowing a form to diplay the correct text in a combo box, and then when the form is submitted to the server to update the record the new numeric value is stored. I am using Dreamweaver MX 2004. The reason i have seperate tables is just in case i want to change their name etc or even add something without having to recode the app

Please Help

Sorry Should Read
Frequency
Weekly
Fortnightly
PayDay
Monday
Tuesday
Wednesday
Thursday
Friday
YesNo
No
Yes