HI all,
First of all, I'm new to ms access.
I'm busy creating a report writer data base for my work. Currently I have a problem and need help...
my database is as follows;
Tables:
TblArea: list of areas for reporting.
TblMachine: list of machines currently in production
TblDescription: a detailed description of the faults we identify ( I will come back this Tbl shortly)
Tblmain: This table has the following data fields:
Date: date field,
Area: Tblarea(lookup),
Machine: Tblmachine(Lookup)
Description: TblDescription(Lookup).
On the Description I can't add new descriptions once I'm in TblMain. I need to use the drop down menu for it.
What do I do to enable it so I can either select from the drop down menu or add new descriptions?
Attached I included the DB[ATTACH]
Regards,
Rudolf