Hello, I am very new to Access
i have a database that has two tables one for a Storm Structure and one that has Storm Sewers. What i need to do is have an upstream invert field in the storm sewer table use an invert in the Storm Structure table. What i have is a record in the Storm sewers that identifies which field the invert is in the storm Structure table. i also have a upstream structure number in the Storm Sewer Table that is the same as a Structure number in the Storm Structure table. i was wondering how do to this, i know how i would do this in excel but have no idea how to in access.