Airdate Mangement System - Check number & Invoice Number Addtions

Overall Description to the Data Base 1) This is a live database and in full use 2) There is a front end Access DB linked to a backend Access data base. 3) 48 Tables on the backend 4) 185 different queries 5) 126 different forms 6) 29 different reports 7) 14 different macros 8) 14 different modules As you can see by the above, this is not a simple data base and anyone that is not an advanced coder and understands Microsoft Access could quickly have a mess on their hands if they aren’t very sure what they are doing. The good news is that we test extensively before going live because of the obvious problem it would cause if there were errors in the live data base. Item 1: See the two screen shots [Air Dates Search - highlight selected [login to view URL] and Air Dates Search - Move the [login to view URL]] for the change on the “Air Dates” form. It is two points: a) move three columns to the left so it is next to the “local date” column b) when a person selects a row it needs to highlight so as to identify the row all the way across Item 2: Append an “Invoice” field and a “Check Number” field to the “Airdate” table OR create a new table hold those two fields. If it is a separate table it would have to be set up as a relation to the “tblAirdate” table. It will more likely be best to append the table. NOTE: there will have to be way to auto-advance the Check number. This will be used in a later addition to this database. Item 3: When on the Air Dates Search form query a station “KDOC” and then “alt-E” to edit a record. The “Edit Airdate” Form comes up. The two fields added to “Item 2” above will be put in this form, see [Air Dates Search - Move the [login to view URL]] for example. If the two fields end up being in a separate table then a relationship would have to be established between the new table and the “tblAirdate” table.