Search results

  1. A

    Column from other table displays default value even with no matching record?

    Hi all, I'll try to come up with as simple an example as possible to illustrate what's going on. So let's say I have three tables: First, Second, and Third. The tables Second and Third each have a column with a default value of "X". I'm creating a query that selects fields from First...
  2. A

    Validating a field to match a corresponding field in another table

    Kind of an Access newbie here, so bear with me, but I have two tables: a master list of data and another that shares many of the same fields but the data is updated/replaced every so often. Let's say they both share a "Member ID" field. Can I make a validation rule on this field so that you...
Back
Top Bottom