New Table

[Guest]

Hi,

We have a staff database which stores and manipulates all information
relating to our staff. Originally we needed a field in the staff table
called Budget. This is a text field with a combo box and value list. There
are only three different budgets.

This has worked fine until recently, however we have added two new tables
one to monitor agency usage and the other for vacancy info. Both these
tables also require a budget field.

I thought the best solution was to create another table for budgets and
insert the field in to the original staff table along with the two new tables
to avoid duplicating the field. It seems to work fine for the two new tables
but reports generated from the original table will now only display employees
who have a budget specified.

This worries me because some staff may be left off key reports due to simple
errors such as not specifying a budget. Have I done something wrong or
overlooked something? Or maybe I've gone completely the wrong direction with
the problem.

Please help, many thanks

Ian

 

[Duane Hookom]

You can edit the Join properties in your queries to include all the records
from your staff table. Double-click the join line and select the correct
option.