Hi I am using Access 2007. I have a form created from two tables. On each table I have a field named haul which needs to be filled out for every record and the value is same for corresponding record on the other table. The tables are linked by the ID field. Because I'm not very experienced with Access I made the form so that the user has to enter the value twice which is a pain. Is there a function I can use to tell the program if the value for one haul record for one table is null take the value from the other table haul field with the same ID.
example: table one named : Commerical Important Haul log, field name HAUL.
table two: Discarded Species Haul log, field name HAUL
Form:
Haul Number, this value goes to table 1, Discard Haul Number this value goes to table 2.
I would like to get rid of the Discard Haul Number on the form. Thanks for any help.