Pop-up window when mistake in entry (linked tables)

[El Jagang]

Good morning,

I've created two tables (one called [Positions] and the other called [Staff]). They are linked by the position number, which is the primary key in [Positions] and is a required field in [Staff].

I'd like to make it so that if the position number entered in the [Staff] table doesn't match one of the position numbers from the [Positions] table, there would be a pop-up stating that the position number is incorrect. This is to ensure accurate data entry, as a mistake in the position number in the [Staff] table can lead to inaccurate reports.

Any help would be appreciated.

 

[spikepl]

Thats not the way. You also never allow operations on tables directly.

You prevent user from being able to make the mistake by providing proper user interface in a form. In a form you'd have a combobox with only available positions in it.

 

[El Jagang]

Thanks. I'm still trying to get a grasp of programming logic.